Highlighting and copying in Excel

[Solved/Closed]
Report
-
 DannyBoy -
Hello,

I am just starting on visual basic and would like to record a macro whereas, once I have pressed play, Excel will select a cell 12 rows down from where I have selected, copy a range of cells, 8 across and 12 down, highlight this boxed area and then copy it ( I will then paste this into a non-Microsoft program) .

I can write small parts of this but not enough!

All help appreciated!

Dan

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Try this
Sub doPrepCopy()

   With Range(ActiveCell, Cells(ActiveCell.Row + 11, ActiveCell.Column + 7))
      .Select
      .Copy
   End With
   
End Sub
I have then added

ActiveCell.Offset(12, 0).Select

To get to the next set of 12

Thanks for your help!