| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I create a macro to "Go To" a location specified in a cell?
Based on user input, I have used formulas to create a variable location in
cell A1. I need a macro that will "Go To" that location. Since the row and column are variable I can't use a Range Name. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I create a macro to "Go To" a location specified in a cell?
Hi Kim
Try this Range(Range("A1").Value).Select -- Regards Ron de Bruin http://www.rondebruin.nl "kim.in.denver" wrote in message ... Based on user input, I have used formulas to create a variable location in cell A1. I need a macro that will "Go To" that location. Since the row and column are variable I can't use a Range Name. Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I create a macro to "Go To" a location specified in a c
you are a super star!!!! thank you so much :o)
"Ron de Bruin" wrote: Hi Kim Try this Range(Range("A1").Value).Select -- Regards Ron de Bruin http://www.rondebruin.nl "kim.in.denver" wrote in message ... Based on user input, I have used formulas to create a variable location in cell A1. I need a macro that will "Go To" that location. Since the row and column are variable I can't use a Range Name. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Simple way to get cell location as text "A2" | Excel Worksheet Functions | |||
| within a macro how can I suppress the warning pop "A file named xxxx.xls already exists in this location. Do you want to replace it?" | Excel Programming | |||
Linear Mode
