Code Name of Worksheet in a Formula

[SueDot]

Is there a way to reference cells on a worksheet with a formula using the
Code Name of the worksheet? (i.e. "Sheet10", as opposed to "Oct 2009")

 

[Dave Peterson]

You may be able to do this using a User Defined Function--but I wouldn't.

I would imagine that you'd be passing strings to that function--and that means
that those formulas wouldn't update correctly if the codename were changed or
the worksheet was deleted.

And I would guess that if you were trying to retrieve a value from a cell on
that sheet, you'd have to pass it a string for the address, too.

And if you insert/delete rows or columns, then the formula wouldn't update to
point at the new location.

It would be kind of like replacing all your nicely behaved "normal" formulas
with a bunch of =indirect() formulas.

Is there a real reason you need to do this?