Range name AKA?

[Locoguy]

I'm having a mental moment... so I'm asking for assistance from "The Board":ray:

I have a range (A2:A10) that has a range name of "Apple"... I want to refernce this same range of data, but with a different name... In this example "Orange" IS there a way in VBA code to add the range name "Orange" and have it define the same range as "Apple"? (ie Orange = Apple?)...

BTW... I need a vacation...
Loco

 

[Aladin Akyurek]

Why don't you simply do so by means of the Name Box on the Formula Bar,Formulas | Name Manager or Insert | Name | Define?

 

[Scott Huish]

Range("Apple").Name = "Orange"

 

[Locoguy]

Thanks for the reply.. Let me see if it works... here goes...

 

[Locoguy]

BRILLIANT !

Thanks a bunch Scott... !!!

 

[Locoguy]

OK... One last question... I have 2 columns Column A has the names I have already assigned in my macro, Column B has the "AKA" name that I want to add... Any suggestions how I can loop through column a and assign the column B names?

Loco

 

[Scott Huish]

What do you mean loop through column A, don't you want to loop through the values in Column B and assign those names to the range A2:A10. My other question is why are you doing this?

 

[Locoguy]

The reason behind this is: I sometimes have data from 2 sensors in line with one another and my macro is built around this assumption. NOW, I'm having instances were I don't have one of the two sensors... Usually, the sensors have very similar readings, so inorder to keep things moving along, I'm naming the missing sensor data to the range of the data that I do have. I'm setting up a list of the names that I do have and a corrisponding list of the names that I would want to have the same data range. Just need a way to 1. look for one of the column names and 2. loop through the names and assign the corrisponding alias names (apple=orange).


Thanks !


Sincerely,


Loco

 

[Scott Huish]

So all the range names are in column B, and they all apply to range A2:A10?

 

[Locoguy]

Correct, range names would be in A2:A10 and in B2:B10 would be the corrisponding alias name.

Thanks !


Loco