macro to select a range of cells following an offset?

  • Thread starter Thread starter Wes_A
  • Start date Start date
W

Wes_A

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?
 
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
 
Back
Top