Previous Topic Next Topic

How do I select a row in a macro

Closed
Dreamer - 13 Aug 2010 à 17:18
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 18 July 2025 - 13 Aug 2010 à 17:39
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
Related:

1 response

Réponse 1 / 1
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 18 July 2025 491
13 Aug 2010 à 17:39
Hi,

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


Best regards

Similar discussions

Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses
Why can't I bridge connect?
ryno -
Qiqi -

15 responses
How to bridge connections from laptop to pc
TEchNoob -
Nilesh Katekar -

13 responses
cannot get my home pc to bridge connections
darrenrst -
corona_king -

3 responses
Ig stories from close friends to public
Darren -
zara -

31 responses