Thread: macro to select a range of cells following an offset?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes_A[_2_] Wes_A[_2_] is offline
external usenet poster
  
Posts: 37
Default 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?
Reply With QuoteReply With Quote