| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display Worksheet If It Exists
I have the following on a button
Sub makesheet() Sheets("Master").Select Sheets("Master").Copy after:=Sheets("Master") ActiveSheet.Name = Format(Now, "dd-mmm") End Sub Trouble is if the sheet already exists I get an error message. What I want is if the worksheet with today's date already exists make it active. If it does not exist create sheet. Thanks Blue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Worksheet BUT If It Already Exists... | Excel Discussion (Misc queries) | |||
| check if worksheet exists | Excel Worksheet Functions | |||
| How to check if a worksheet exists in worksheet collection | Excel Programming | |||
| Worksheet Exists... | Excel Programming | |||
| How can I tell if a worksheet exists? | Excel Programming | |||
Threaded Mode
