Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete sheet
When you create a name in a worksheet, it creates it for the workbook. That
is why is is still there after you delete the sheet. However if you want to get rid of it you can go to the name manager and select it and the delete icon will become active. Click on the delete and it is gone. Skinman "ranswrt" wrote in message ... Is there a problem to not delete the named cells berfore a sheet is deleted? "Mike H." wrote: It looks like that is the only way to get them to disappear from the "F3" list. "ranswrt" wrote: I have a procedure to delete a sheet in a workbook. All the named cells in that sheet gets deleted. When I use the 'F3' to paste the list of named cells, the cells in the sheet that was deleted appear in it. Do I need to delete the named cells before I delete the sheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete ROW on Sheet#1 corupts data on Sheet#2 | Excel Worksheet Functions | |||
Delete a sheet | Excel Worksheet Functions | |||
Delete values in sheet 2 that arre found in sheet 1 | Excel Discussion (Misc queries) | |||
Delete rows from one sheet containing deatils on the second sheet | New Users to Excel | |||
delete content of one sheet off another sheet | Excel Programming |