Dim nameSheet as string

variable nameSheet has to be the name of the current sheet, what do
have to use

--
Zur
-----------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=26418

one way:

Dim nameSheet As String
nameSheet = ActiveSheet.Name

In article ,
Zurn wrote:

Dim nameSheet as string

variable nameSheet has to be the name of the current sheet, what do I
have to use?

dim MyBook as string
dim MySheet as string

MyBook = ActiveWorkbook.Name
MySheet = ActiveSheet.Name

-----Original Message-----

Dim nameSheet as string

variable nameSheet has to be the name of the current
sheet, what do I
have to use?


--
Zurn
----------------------------------------------------------
--------------
Zurn's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14645
View this thread:
http://www.excelforum.com/showthread...hreadid=264183

.