myvar = Activesheet.Name

--
Regards,
Tom Ogilvy


"wild_fish99"
wrote in message
...

Is there any function in visual basic that will return the current
worksheet name? I am currently working on a program that tries to
assign it to a variable and I cannot seem to get the syntax right.


If anyone can help that would be great.

Thanks in advance!


--
wild_fish99
------------------------------------------------------------------------
wild_fish99's Profile:
http://www.excelforum.com/member.php...fo&userid=8345
View this thread: http://www.excelforum.com/showthread...hreadid=490639