| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a cell value to point to desired location.
scenario 1: say, if cell A1 contains the value 10,2 and cell D1 contains
value 8. scenario 2: say, if cell A1=10, cell B2=2 and D1=8. how can I write a macro to select the cell J2 (ie. 10,2) and place the value 8 in it? ie. use the values as an X,Y coordinate. Which would be the more efficient way of doing it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save File in Desired Location & Name | Excel Discussion (Misc queries) | |||
| Using a variable to point to a location | Excel Worksheet Functions | |||
| Decimal point location | Excel Discussion (Misc queries) | |||
| Data point location | Charts and Charting in Excel | |||
| Return the location of data point on a chart | Excel Programming | |||
Threaded Mode
