You have an alternate suggestion at your other thread.

ppbedz wrote:

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

--

Dave Peterson