Martin

Are you saying the names are the results of formulas that link to the other
sheets?

Can you just copy then Paste Special(in place)ValuesOKEsc.


Gord Dibben Excel MVP

On Thu, 03 Feb 2005 13:26:27 +0000, Martin ©¿©¬ @mandeREMOVETHIS.plus.com
wrote:

Many thanks Dave & Gord
That works great on a normal worksheet
However, what i forgot to mention in that my worksheet is LINKED to
14 other sheets and this doesn't seem to work with linked data

So is there a solution before i make an unlinked worksheet?

Regards
Martin
©¿©¬