View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GeneWan GeneWan is offline
external usenet poster
 
Posts: 21
Default 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?