checking multiple sheets.
res = application.Match(activesheet.name,Array("sheet1", "sheet2"),0)
if not iserror(res) then
exit sub
End if
--
Regards,
Tom Ogilvy
"Scott" wrote in message
...
Hi,
Can someone please help me with my macro.
I'm trying to create a macro that will check the name of the active sheet
from a list in an array, or something like that, if this sheet is in the
list of named sheets then exit the sub.
Is this possible?
Hope someone can help,
Thanks
Best regards,
Scott
|