| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
|
#2
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 |
| 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 | |||
Hybrid Mode
