referring to tab label in formula
 

can i refer to a tab label in an excel formula?

referring to tab label in formula
 

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0002.html

--
Regards
Frank Kabel
Frankfurt, Germany
"aben68" schrieb im Newsbeitrag
ups.com...
can i refer to a tab label in an excel formula?

referring to tab label in formula
 

This selects the sheet and then renames it.
Sub Macro1()
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "SheetZ"
End Sub


"aben68" wrote:

can i refer to a tab label in an excel formula?