| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Address of Maximum value in Cell | Excel Worksheet Functions | |||
| Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
| cell address rather than range name | Excel Discussion (Misc queries) | |||
| Pound (#) signs instead of text | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
