View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TBA[_2_] TBA[_2_] is offline
external usenet poster
 
Posts: 58
Default How to verify specific Worksheets are present

Windows 2k Pro
Excel 2000

I have a Workbook on which I need to do a relatively simple check using VBA
code. I want to scan the Workbook for four specific Worksheets (for example
the worksheets are named "Red", "Blue", "Green" and "Purple"). If any of
these are missing then I'd like to create a new Worksheet with the missing
name(s), AND I'd like to delete any Worksheets that are NOT named with one
of the four mentioned names.

I'm pretty sure I could do this, but I'm afraid my method would not be very
efficient at all. How many steps could this be done in? Or, what is the
most efficient way to do this?

TIA!

-gk-