Removing `named range´ from worksheet
 

I have an existing spreadsheet (ss) which has numerous worksheets with
named ranges on them. I'd like to REMOVE the named ranges without
deleting the VALUES in the cells. The RANGES are presently linked to
exterior text files. Please advise!!

Also.. would like to make NEW named ranges of cells afterwards.

-Gregory

Removing `named range´ from worksheet
 

Hi Gregory,

Below is a link to an excellent Name Manager ...
http://www.jkp-ads.com/officemarketplacenm-en.asp

Removing `named range´ from worksheet
 

I think you want to paste the values into the cell rather than the reference.
If use use ocpy then paste special (in the edit menu) you can select value.
You may want to keep the old values, so I would add a new column, then hide
the old column so you don't loose the refernce information.

"Gregory" wrote:

I have an existing spreadsheet (ss) which has numerous worksheets with
named ranges on them. I'd like to REMOVE the named ranges without
deleting the VALUES in the cells. The RANGES are presently linked to
exterior text files. Please advise!!

Also.. would like to make NEW named ranges of cells afterwards.

-Gregory

Removing `named range´ from worksheet
 

On Feb 15, 11:17 am, "Carim" wrote:
Hi Gregory,

Below is a link to an excellent Name Manager ...http://www.jkp-ads.com/officemarketplacenm-en.asp

Thanks.. have added it in.
Also printed the 20-page doc.
Will be giving it a go today.

-G