Use worksheet number instead of name in formulas

[Tim Ricard]

Good morning everybody,

I have looked through a few groups and I haven't been able to find
what I need to do, so here goes:

is there a standard function/formula that allows you to reference the
work sheet number rather than the worksheet name when referencing a
cell in a different worksheet than you are currently in?

i.e.:

instead of this: "='My worksheet name'!A1"
do this: "=sheet(1)!A1"

If there is no standard, then I will just make the VBA, but no use
doing that if it is not necessary

Tim

 

[Gord Dibben]

Only through VBA.


Gord Dibben MS Excel MVP

 

[Tim Ricard]

Thanks for the help Gord. I will get right on it .

Tim