I take it that you have a named range in the worksheet and you want to
assign another name to the same range. Say the range is now named Doodle.
Say you want to name it NextDoodle also.
A worksheet range can be named as many different names as you wish.
Do this:
Range("Doodle").Name = "NextDoodle"
When you set a VBA variable to a worksheet range, you are not naming that
range that variable.
If you have already set a VBA variable name (say MyVBAVar) to some worksheet
range, and you want to assign a worksheet name (say Doodle) to that range,
do this:
MyVBAVar.Name = "Doodle"
HTH Otto
"brachistochrone"
<brachistochrone.27ju0m_1147192802.3204@excelfor um-nospam.com wrote in
message news:brachistochrone.27ju0m_1147192802.3204@excelf orum-nospam.com...

Hi,

The variable rng_MGXdataSemiAnnual exists in the dropdown box in the
worksheet and refers to a matrix in the worksheet. There is a similar
matrix on a number of different worksheets, each with its own name

In the VBA, I define a new variable rng_MXGdata:

rng_MXGdata = [rng_MXGdataSemiAnnual]

This new variable is not recognised as a name in the names collection.
I tried using the following:

Names.Add Name:="rng_MGXdata", RefersToLocal:=rng_MGXdata

but it doesn't seem to make rng_MXGdata appear in the dropdown box.
Perhaps this is because you can't have two names referring to the same
ranges? Do I have to delete rng_MXGdataSemiAnnual from the names
collection before rng_MGXdata can be recognised? I need it as part of
the name collection so I can use it in commands like the following:

Offset(3).Formula = "=VLOOKUP(R[-3]C,rng_MXGdata,3,FALSE)"

I will also need to finally delete rng_MXGdata from the "workspace" and
restore the original rng_MXGdataSemiAnnual so if anyone can suggest how
to do go about this I would be grateful.

Your help is appreciated.

Thanks,

Edward


--
brachistochrone
------------------------------------------------------------------------
brachistochrone's Profile:
http://www.excelforum.com/member.php...o&userid=34274
View this thread: http://www.excelforum.com/showthread...hreadid=540353