excelchallenged Wrote:
a5 is an integer variable from 15 to 925 in increments of 1. When a5 i
20
cell a10 (or any cell I chose) should read the contents of j20. When a
is
825 cell a10 should read the contents of j825. The integer value in a5
defines the row of column j returned in cell a10.

why not
temp=[A5]
cells(10,"A").value=cells(temp,"j").value

A V Veerka

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=50917