Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
try [code] next
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |