The following FOR statement loops through each worksheet
in the active workbook, add your code below to check the
worksheet name and if the FOR loop has finished, add a new
worksheet named (X).

For Each Worksheet In Worksheets

This is the only way i know of checking if a particular
worksheet name exists.

-----Original Message-----
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
.