Move to a cell based on the address in another cell

  • Thread starter Thread starter stvn.taylor
  • Start date Start date
S

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
 
Back
Top