Try

Range("A5:J" & R.Value).Select


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




"ppbedz"
wrote in message
...

Thank you.

Next question....

How do I substitute r.Value into my range statement below? I
essentially want to say from A5 through r.Value


Range("A5:J65000").Select


Thanks Again! :)


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