To: Gary's Student re: 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!

Assuming r.value is an address, you can use

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

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.

Originally Posted by mrice

Assuming r.value is an address, you can use

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

Do you mean

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


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



"ppbedz" <ppbedz.26fcm0_1145304001.947@excelforum-nospam.com>
wrote in message
news:ppbedz.26fcm0_1145304001.947@excelforum-nospam.com...
>
> 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
>

Try

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


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




"ppbedz" <ppbedz.26fbwz_1145303104.2315@excelforum-nospam.com>
wrote in message
news:ppbedz.26fbwz_1145303104.2315@excelforum-nospam.com...
>
> 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
>

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