sheet name

M

mdcerino

is there a way to have a cell reference a sheet/tab name? I want cell A
to say the name of the shee
 
J

JE McGimpsey

One way:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

The worksheet must be saved first.
 
D

davezuspann

I need the exact same thing. surely there is a way to
create a formula for this. No way I have to do this by
hand. Can anyone help us? How can you reference a
worksheet tab by using a cell value reference that can be
copied?
 
D

Don

Hi JE,

Thanks for that reply...although I'm not the orginal
poster, I like that and will store it for future use.
Also found out that once the WB is saved you can change
the name of the sheet and A1 or whatever changes with it,
without having to save the Book again. But then, you
probably already knew that......:)

Thanks again,

Don
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a Name 2
Combining two sheets of data into one and sorting by value - using macros 5
Visio: copy text of a master shape to User-define Cells (Variable) 0
Need a function to match unidentical strings 0
VBA code to import worksheets from other workbooks 9
Cell data entering slow! 0
Multiple Criteria Pickup 1
Help with a running total on multiple sheets 2

Top