if you set up two range objects
dim rng1 as range
and set one to the first cell in which you are interested eg set
rng1=worksheets("sheet1").range("A3") and one to the cell on the second
sheet; you can use offset to address the particular cells in which you
are interested eg

rng2.offset(0,3)=rng1.offset(-2,4)

does this help

Callan Wrote:

I would like to say something to the effect of:
Find the last record inserted (the last row on the sheet):
eg: Set rRng = Range("A3:A" & Range("A" & Rows.Count).End(xlUp).Row),
but
for the entire row.
Then I need to be able to say something like:
Set Sheet2 C10 = rs!sheet1 B3

ANY assistance would be greatly appreciated.
Thanks in advance.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=529521