Selecting cells in the active row

[steve case]

Good morning all, here I am at the well again

I want to write VBA code to select the data in the active row.

If my data is in Range(A1:K999) and the active cell is G22 then I should like a macro to select Range(A22:K22) or if it's B9, Range(A9:K9) will be selected and so on.

 

[Richie(UK)]

Hi S,

How about:

Sub Test()
    Dim l As Long
    l = ActiveCell.Row
    Range(Cells(l, "A"), Cells(l, "K")).Select
End Sub

HTH

 

[steve case]

Beautiful!

ray:

That was not in Chaper 11 of Walkenback's book!

And it only took ten minutes!