Thread: macro to select a range of cells following an offset?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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 With QuoteReply With Quote