How do I select a row in a macro

Closed
Dreamer - Aug 13, 2010 at 05:18 PM
aquarelle
Posts
7103
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
May 21, 2022
- Aug 13, 2010 at 05:39 PM
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

1 reply

aquarelle
Posts
7103
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
May 21, 2022
490
Aug 13, 2010 at 05:39 PM
Hi,

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


Best regards
0