View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 168
Default If Worksheet exists...Then run code

I'm looking for some code that will allow me to search for a specific
worksheet.

If it doesn't exist, then run some code.
The code below obviously doesn't work. How can I rewrite this?


If Sheets(CurrentModel).Activate = Error Then
'run code'

Else
Sheets(CurrentModel).Activate
End If


Thanks,
Paul