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

"Elkar" wrote in message
...
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


"DK" wrote:

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