Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Mike
What you need to do is to loop through the worksheets collection, while looking at each worksheets name. The following code should serve as an example Sub FindASheet() ' Local Variables Dim wks As Worksheet Dim blnWksPresent As Boolean For Each wks In Application.Worksheets If wks.Name = "Feed Sheet (1)" Then blnWksPresent = True End If Next wks If Not blnWksPresent Then Exit Sub End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |