| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking if the sheet already exists
Hi,
I have the following code now, Is there a more efficient way to do this ? For Each sh In ActiveWorkbook.Sheets counter = 0 If sh.Name = "Singles" Then MsgBox ("Sheet 'Singles' already exists") counter = 1 End If Next If counter = 0 Then Set sh = Sheets.Add sh.Name = "Singles" End If Thank you, -- ______ Regards, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking to see if a file exists. | Excel Discussion (Misc queries) | |||
| Checking if Sheet Exists? | Excel Discussion (Misc queries) | |||
| checking if an url exists | Excel Programming | |||
| Checking to see if a worksheet exists | Excel Programming | |||
| Checking if a worksheet already exists... | Excel Programming | |||
Threaded Mode
