T
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
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
.