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?

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?