Macro to select columns A to L from the selected A Column cells

[caligirl626]

Hello everyone. Looking for a macro that will copy row information from column A through L.

This code below copies a single row, in this case Row 2, cells A2:K2, as shown above.

Sub Macro1()
'
' Macro1 Macro
'

'
    ActiveCell.Range("A1:K1").Select
    Selection.Copy
End Sub

How can the code be modified to copy all the columns, A thru K, of user selected A column cells?
For the example shown below, if cells A4 to A7 are selected, the macro should copy array A4:K7

The macro should consider that the number of the user selected column A cells will vary. TIA

 

[Fluff]

Ok, this is now a significantly different question & so needs a new thread. Thanks