Do you mean

Range("A5:J" & R.Row)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ppbedz"
wrote in message
...

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