View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] stvn.taylor@gmail.com is offline
external usenet poster
 
Posts: 4
Default Move to a cell based on the address in another cell

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