delete sheet
 

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

delete sheet
 

Thanks for your help

"Dave Peterson" wrote:

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