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

.