simonc
12-10-2008, 12:34 PM
I am an experienced Excel user but a novice at VBA programming. I am trying to achieve the following via a macro and need some help!
I want to take the value in the active cell (text) and use it to lookup a value in a range on another worksheet in the workbook corresponding to the text in the active cell . The value looked up in the lookup table is a range name that I want to make the active cell.
For example:
Text in the active cell = WD:-1
Lookup Range:
A1 A2
WD:-1 CM1
WD:-2 CM2
WD:-3 CM3
etc.
CM1 is a range name that I would like to make the active cell. I have tried several approaches to this but failed, mainly due to my lack of VBA knowledge (learning all the time!). I would be most appreciative if anyone can put me on the right track.
I want to take the value in the active cell (text) and use it to lookup a value in a range on another worksheet in the workbook corresponding to the text in the active cell . The value looked up in the lookup table is a range name that I want to make the active cell.
For example:
Text in the active cell = WD:-1
Lookup Range:
A1 A2
WD:-1 CM1
WD:-2 CM2
WD:-3 CM3
etc.
CM1 is a range name that I would like to make the active cell. I have tried several approaches to this but failed, mainly due to my lack of VBA knowledge (learning all the time!). I would be most appreciative if anyone can put me on the right track.