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

Possible to refer to a sheet's object name ? 1
Can I use a worksheet name in a formula? 4
copied formulas refer to destination sheet not source sheet 2
Refer to Previous or Next Sheet 3
INDIRECT with Sheet Level Defined Name 2
Vlookup and return sheet name also 2
reference work sheet name by using a formula 3
Refer to the previous worksheet in a formula 2

Top