Escape Character

[Carl]

Attempting to reference another worksheet within a cell;
Sense the worksheet name is dynamic I want to use a
formula to reference the worksheet name ...'tab[1-
50]'$c$3...the items in bracket will get its number from
another cell.

 

[Andy Brown]

=INDIRECT(C1&"!A1")

, where tab name is in C1. So if C1 = "Sheet2", the formula returns
Sheet2!A1.

Rgds,
Andy

 

[Carl]

Thank you! What about copying a Tab name into a cell?...I
want to automatically copy the current Tab's name into a
cell.

 

[Andy Brown]

This formula will return the tab name in any of its cells -

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

The file must be saved first or it'll return an error.

HTH,
Andy