Thread: Deleting sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brandi[_2_] Brandi[_2_] is offline
external usenet poster
 
Posts: 2
Default Deleting sheet

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

.