Move to a cell based on the address in another cell

[stvn.taylor]

Hi All,

I would appreciate any assistance in figuring out how to accomplish
the following in
VBA.

In my spreadsheet I have a formula that returns the row and column
address
of a specific cell depending on a set criteria. Lets say that this
formula is in
cell A1. The contents of cell A1 reads D5. What I need is for the cell
D5 to be
selected. Should the result in A1 change to say E10, then I need cell
E10 to be selected etc.

I am using excel 2003 with windows XP.

Thanks,

Steve

 

[Rick Rothstein \(MVP - VB\)]

Give this a try...

Range(Range("A1").Value).Select

Rick

 

[sgltaylor]

Hi Rick,

That worked great!

Thanks,

Steve

Give this a try...

Range(Range("A1").Value).Select

Rick