| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If Sheet exists, GOTHERE, else create it
"CLR" wrote in message ... Thanks Bob...... After a little massaging, it worked fine in my XL97 (sorry, forgot to mention in original post) ' Worksheets.Add.Name = Worksheets("SpecificSheet") Worksheets.Add.Name = ("SpecificSheet") 'changed above line Really? You surprise me. Going to dig out my old NT4 machine and check this :-) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Hyperlink only if file exists | Excel Discussion (Misc queries) | |||
| Create Worksheet BUT If It Already Exists... | Excel Discussion (Misc queries) | |||
| Test if folder exists, create if it doesn't? | Excel Programming | |||
| Test if a folder exists, create if it doesn't? | Excel Programming | |||
| How can I know if a sheet exists ? | Excel Programming | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
