Hi,
in the beginning of my code, several worksheets are being created:
ActiveWorkbook.Sheets.Add.Name = "Information_Database_Searches"
ActiveWorkbook.Sheets.Add.Name = "Information_Holdings"
ActiveWorkbook.Sheets.Add.Name = "Information_AgR_Publications"
ActiveWorkbook.Sheets.Add.Name = "Information_Pres_Reports"
ActiveWorkbook.Sheets.Add.Name = "Information_IntellProp"

For testing, I want to re-run the macro, but I always have to delete
these already created sheets so that the macro runs properly.

How can I write VBA, which first looks of these sheets are already
there. If not - create them, if yes, then go on with next section of
code.

Cheers
Juergen


--
juergenkemeter
------------------------------------------------------------------------
juergenkemeter's Profile: http://www.excelforum.com/member.php...o&userid=25248
View this thread: http://www.excelforum.com/showthread...hreadid=500888