| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if a worksheet exist - VBA
Please help.
In VBA, how do I check if a worksheet exists? Thanks Warren |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if a worksheet exist - VBA
one way:
Dim wkSht As Worksheet On Error Resume Next Set wkSht = Worksheets("TargetSheet") On Error GoTo 0 If Not wkSht Is Nothing Then 'worksheet exists Else 'worksheet doesn't exist End If In article <2ex7b.407150$Ho3.62997@sccrnsc03, "Warren" wrote: Please help. In VBA, how do I check if a worksheet exists? Thanks Warren |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Does worksheet exist | Excel Discussion (Misc queries) | |||
| Check for a tab if it is exist | Excel Discussion (Misc queries) | |||
| Check if a value exist in a column | Excel Worksheet Functions | |||
| Does Worksheet Exist | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
Hybrid Mode
