| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move to a cell based on the address in another cell
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move to a cell based on the address in another cell
Hi Rick,
That worked great! Thanks, Steve "Rick Rothstein (MVP - VB)" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
| how do I move a cell based on a match of another cell in excel? | Excel Worksheet Functions | |||
| I am trying to select a new cell whose row address is based on a variable | Excel Programming | |||
| Remove Civic numbers in Street Address, move to previous blank cell | Excel Worksheet Functions | |||
| Move shape, object, pic to center of new cell based on cell value | Excel Programming | |||
Linear Mode
