| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy Range of Cells in Same Row
If I am in cell K5, how can I select B5:J5 in order to copy and paste it somewhere else? Similarily, If I am in cell K500, how can I select B500:J500 in order to copy and paste it somewhere else? The range I want to copy will always be in the same row as my active cell and always from columns B to J. Thanks, Moe -- Moe ------------------------------------------------------------------------ Moe's Profile: http://www.excelforum.com/member.php...o&userid=12500 View this thread: http://www.excelforum.com/showthread...hreadid=392979 |
|
#2
|
|||
|
|||
|
See this example
http://www.rondebruin.nl/copy1.htm#ActiveCellrow -- Regards Ron de Bruin http://www.rondebruin.nl "Moe" wrote in message ... If I am in cell K5, how can I select B5:J5 in order to copy and paste it somewhere else? Similarily, If I am in cell K500, how can I select B500:J500 in order to copy and paste it somewhere else? The range I want to copy will always be in the same row as my active cell and always from columns B to J. Thanks, Moe -- Moe ------------------------------------------------------------------------ Moe's Profile: http://www.excelforum.com/member.php...o&userid=12500 View this thread: http://www.excelforum.com/showthread...hreadid=392979 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
| Excel-value in a range of cells for two cross references | Excel Worksheet Functions | |||
Linear Mode
