To: Gary's Student cell address reply
 

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

Gary's Student cell address reply
 

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

To: Gary's Student cell address reply
 

Assuming r.value is an address, you can use

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


--
mrice


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

To: Gary's Student cell address reply
 

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

Gary's Student cell address reply
 

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

To: Gary's Student cell address reply
 

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