How do I select a row in a macroClosed

Question

I have a simple problem, how do I write a macro that will simply select what ever row I click on? I simply want to be able to click on a row, run my macro and have it select the entire row. seems like it should be pretty simple but I just can't figure it out. Can someone tell me how to get this done? Thank you.

-=-Ed

aquarelle · Answer

Hi,

Maybe you can try with this :
Sub SelectionRow()
    With ActiveCell
    .EntireRow.Select
    End With
End Sub

Best regards

How do I select a row in a macro

1 reply

Subscribe To Our Newsletter!