| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for sheet name
How would I check to see if there is a sheet named "Sheet1" in the active
workbook. Sub CheckFor New Sheet() If sheets("Sheet1") does not exist in this WB Then MsgBox ("No sheet has been added") Exit Sub Else End If continue... End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check if sheet exists | Excel Discussion (Misc queries) | |||
| Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
| Check changes on a sheet | Excel Programming | |||
Threaded Mode
