Give this a try...

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

Rick


wrote in message
...
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