View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob[_16_] Rob[_16_] is offline
external usenet poster
 
Posts: 2
Default Find existing worksheet

Hi,

Hoping someone can help me.

I am creating a Macro in Excel 2000 and have run across a
problem. I have a file with numerous worksheets but
would like to search for one particular worksheet 'RECORD
TYPE THREE' in the file and if not found then add a new
worksheet with that name. I can add a new one, but do
not know how to search for an existing worksheet by that
name. Any help would be greatly appreciated.

Thanks,
Rob