View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NezRhodes NezRhodes is offline
external usenet poster
 
Posts: 7
Default How do I check if a sheetname exists in a file?

Hello experts, I am a real novice so be patient please. I want to create a
script that allows me to check whether a particular worksheet exists in a
workbook. At the moment my script assumes 'sheet 1' exists:

[Sheets("Sheet 1").Delete]

However, if the sheet has been manually deleted by the user my macro crashes.