View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Evanovich Sean Evanovich is offline
external usenet poster
 
Posts: 3
Default Does sheet exist?

What's the proper way to check and see if a specific
sheet exits in the workbook?

I need to pull data from this sheet IF it exists...and if
it doesn't exist I need to pull data from another sheet I
know will be there...

If "Multi-Acct Summary" exists then
GetDataFromMultiAccount
Else
GetDataFromSingleAccount
End if

Thanks!!!