replacing excel names

[cwellswellsc]

Hi,

I am having difficulties when I try and change the name property of a cell that already has a name. Basically this doesn't seem to do anything!
So I tried to add them to the names object and this does work, however the old entry still exists. Basically, any suggestions on how to avoid this would be appreciated. I could delete the offending name if I could use the RefersTo property to find it (i.e. for the current cell I know the refersto, its just the cell reference, so tell excel to delete all names with that refersto value ... but I don't know how to do this!

Any help appreciated.

Carl

 

[Aladin Akyurek]

On 2002-04-18 02:49, cwellswellsc wrote:
Hi,

I am having difficulties when I try and change the name property of a cell that already has a name. Basically this doesn't seem to do anything!
So I tried to add them to the names object and this does work, however the old entry still exists. Basically, any suggestions on how to avoid this would be appreciated. I could delete the offending name if I could use the RefersTo property to find it (i.e. for the current cell I know the refersto, its just the cell reference, so tell excel to delete all names with that refersto value ... but I don't know how to do this!

Any help appreciated.

Carl

Activate the option Insert|Name|Define.
Select the name that you want to delete.
Activate Delete.

 

[cwellswellsc]

ahh sorry, I wasn't being clear enough. I'm trying to do it from VBA ...

C