How can I refer to sheet number not sheet (name)?

D

DK

xl-2007
In a worksheet formula, is there a way to refer to another worksheet by
index number an not by it's given name?
I'd rather not us VBA if possible.
Thanks.
DK
 
E

Elkar

The short answer is no, you'd need VB Code for this. But, there are a few
tricks, such as inserting hidden sheets, or creating a dynamic list of sheet
names that may work. It really depends what you need to do.

If you share some more details on what you're trying to accomplish, perhaps
we could make a suggestion.

HTH
Elkar
 
D

DK

Elkar,
Thanks for the reply. I found code for returning sheet names using a UDF
"OffsetSheet()".
I'll play around with it.
Thanks again.
DK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Possible to refer to a sheet's object name ? 1
VBA for Dependents shortcut menu 0
Finding a Name 2
reference sheet number not name 1
how to copy and paste value from one sheet to another 4
Converting a number into a cell reference 2
How do I have a cell value define a dynamic named range? 15

Top