| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if a worksheet exists
Hi all
I am looking for a way to get VBA to check if a worksheet exists using a named range as the source and if the sheet does not exist then add the required sheet name... the only examples I have been able to find use the following code If SheetEsists("sheetname") = True Then. However, this does not appear to be a known function within Excel 2000..... Is there another way or am I missing something? Regards and Thanks Mort_kombat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check if worksheet exists | Excel Worksheet Functions | |||
| check if worksheet exists | Excel Programming | |||
| How to check if a worksheet exists in worksheet collection | Excel Programming | |||
| Check whether a worksheet exists already | Excel Programming | |||
| check if worksheet exists | Excel Programming | |||
Threaded Mode
