Sorry, I needed to bo more clear. I need to retain the J and use the
row portion of the r.value address.

Note: J is the last column in the sheet I am copying from, bit it can
have a variable number of rows.



mrice Wrote:
Assuming r.value is an address, you can use

Range("A5:" & R.value).Select


--
ppbedz
------------------------------------------------------------------------
ppbedz's Profile: http://www.excelforum.com/member.php...o&userid=33559
View this thread: http://www.excelforum.com/showthread...hreadid=533519