macro to select a range of cells following an offset?

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?
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Offset from an Application.Goto cell = Date or Time 10
Copy to a mid column range Row 10 - Row 20 4
Clean this select case code up a bit. 2
VBA Code to select and format range 2
Need better macro 3
Clear a "moving" range offset from Target 31
Code for multiple select of cells 16
Select contiguous cells by ActiveCell.Interior.ColorIndex and applyborders 7

Top