checking if a sheet exists
looping through the sheets and checking each name
--
Regards,
Tom Ogilvy
"greg" wrote:
Is there a good way of checking if a sheet exists?
Besides doing this
excel.ActiveWorkbook.Sheets("foo").name
and catching the error that is thrown.
|