Use worksheet number instead of name in formulas

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
Fri May 09 11:34:03 CDT 2008

Only through VBA.


Gord Dibben MS Excel MVP

On Fri, 9 May 2008 06:35:08 -0700 (PDT), Tim Ricard <tricard@gmail.com> wrote:

>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

Tim
Fri May 09 13:12:09 CDT 2008

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

Tim