LinkBack URL
About LinkBacks
I've seen examples here where you can use "dim" and a subroutine, but isn't there a simpler way? Isn't there something like:
if exists("sheetname") then
delete "sheetname"
Is there no function specific to this?
I've seen examples here where you can use "dim" and a subroutine, but isn't there a simpler way? Isn't there something like:
if exists("sheetname") then
delete "sheetname"
Is there no function specific to this?
There isn't a specific function to check if a sheet exists, but it is easy to write your own. For example:
Although, since the end result either way is that you want a workbook without the sheet, I'm not totally convinced checking to see if it exists first is entirely necessary.
Please Login or Register to view this content.
Last edited by Colin Legg; 11-13-2011 at 09:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks