Highlighting and copying in Excel Solved/Closed

Question

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

rizvisa1 · Answer

Try this

Sub doPrepCopy()

   With Range(ActiveCell, Cells(ActiveCell.Row + 11, ActiveCell.Column + 7))
      .Select
      .Copy
   End With
   
End Sub

DannyBoy · Answer

I have then added

ActiveCell.Offset(12, 0).Select

To get to the next set of 12

Thanks for your help!

Highlighting and copying in Excel

2 responses

Similar discussions

Subscribe To Our Newsletter!