Select Cell based on Variable address

[achidsey]

Excel Experts,

I have a spreadsheet similar to:

A B
1 Symbol Shares
2 DELL 25
3 HWP
4 INTC
5 AMD


I have assigned the temporary varaible LastSymbol to Cell A5
The currently selected cell is B1, which contains "Shares"

I now want to select cell B5 based on the fact that it is the cell with the
same row as the variable LastSymbol and the same column of the current
Selection.

What is the code to do this?

Thanks in advance,
Alan

 

[Bob Phillips]

I am assuming that LastSymbol is a range variable.

Cells(LastSymbol.Row, Activecell.column).Select

 

[achidsey]

Bob, thanks for the response. Alan