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?
|