Excel doesn't allow duplicate sheet tab names. Are you trying to assess a
proposed name?
Activesheet.Name will give you the sheet tab name.
--
Regards,
Tom Ogilvy
"halem2" wrote in message
...
HI:
I'm trying to create a sub that would check for duplicate sheet tab
names and pop up a msg to the user.
Can anyone please tell me what the object name is for the Tab name???
thanks
--
halem2
------------------------------------------------------------------------
halem2's Profile:
http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=262888