I am new to Excel VBA programming, and I am using version 2010. 

I am trying to copy the contents of the cells in the columns listed in the array, so I can paste them on another worksheet. 

The columns will stay the same but I want the row to be wherever the active cell is. The code is linked to a button. 

When I Dim the array with a cell integer this works like a charm. I am hoping that there is a way to make the array dynamic with the row number being based on the active cell. 

```
Dim x As Integer
Dim myarray As Variant
x = ActiveCell.Row
myarray = Array("Ax", "Fx", "Ix", "Jx", "Kx", "Rx")

With ThisWorkbook.Worksheets("HANDOVER")
  Cells(x, myarrray).Select
  Selection.Copy
End With

```