Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yet I already know the names of the sheets I will need to
delete, but by just deleting the sheet, it does not delete the code that applies to that sheet, so an error appears. Should I maybe set the macro up in a different way??? Also, the direction that you gave to add a new sheet...how do I get the macro to import a file and do the proper text editing, etc. like I have set up for the other sheets? -----Original Message----- Do you already know the name of the sheet or sheets you want to delete? As for the adding of sheets. Sheets.Add Then i usually name them immediately after i create them. ActiveSheet.Name = "Name of Sheet" -- SCSA25 ---------------------------------------------------------- -------------- SCSA25's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=15106 View this thread: http://www.excelforum.com/showthread...hreadid=267386 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keep sheet from deleting contents | Excel Worksheet Functions | |||
Deleting a sheet | Excel Programming | |||
Deleting Sheet | Excel Programming | |||
Deleting Many Cells on a Sheet | Excel Programming | |||
Deleting a Sheet | Excel Programming |