Cell Reference to a tab name on Excel

[petercav]

Hi,

Is anyone aware of how to make reference to a tab name on a spreadsheet.

ie - I want cell A1 to show me what the tab name is. So if the tab name is June 06, I want this to show up on cell A1.

Any help on this is greatly appreciated

Regards

Petercav

 

[xlbo]

please look in the FAQs section before asking questions:

faq68-2561

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question