| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to select a range of cells following an offset?
MS Office (Excel) running on XP Pro:
I am wanting to select a range consisting of the six cells following the one arrived at by: ActiveCell.Offset(0,1) in the same row. The row number would be different each time the offset is run. I would then copy the data in these six cells. Can anyone assist? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to select a range of cells following an offset?
Hi,
There's no need to select the cells to copy them,use this ActiveCell.Offset(, 1).Resize(, 6).Copy but if you feel you want to select use this ActiveCell.Offset(, 1).Resize(, 6).select Mike "Wes_A" wrote: MS Office (Excel) running on XP Pro: I am wanting to select a range consisting of the six cells following the one arrived at by: ActiveCell.Offset(0,1) in the same row. The row number would be different each time the offset is run. I would then copy the data in these six cells. Can anyone assist? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using offset to select a range | Excel Programming | |||
| Help in using an Offset in a .Range().Select | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
| Select Range - using Offset ( 40 ,0 ) - not working | Excel Programming | |||
| Select and Copy Range using Offset | Excel Programming | |||
![Wes_A[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
