Hi guys,

Just a quick one, is it possible to point directly to the contents of a
cell that is in a range, although we done know where, without using a
loop to check each cell. For example (note sure which is more correct,
but you get the idea)

MyCell.Offset(0, 3) = wkBk.Worksheets("All Data
Unnarr").Range("B1:B500").Cells("C-ACCOUNTS Total").Offset(0, 3)

or

MyCell.Offset(0, 3) = wkBk.Worksheets("All Data
Unnarr").Range("B1:B500").Range("C-ACCOUNTS Total").Offset(0, 3)

Thanks,

Tom


--
Tomski
------------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824
View this thread: http://www.excelforum.com/showthread...hreadid=500720