ps.

You may want to start using local/worksheet names instead of global/workbook
names.

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