You could delete the names before or after you delete the worksheet--or you
could let those invalid names just stick around.
If you're working with names, get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager:
You can find it at:
NameManager.Zip from
http://www.oaltd.co.uk/mvp
You'll find it very valuable.
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
--
Dave Peterson