Previous Topic Next Topic

How do I select a row in a macro

Closed
Dreamer - Aug 13, 2010 at 05:18 PM
aquarelle Posts 7185 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 - 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 response

Answer 1 / 1
aquarelle Posts 7185 Registration date Saturday April 7, 2007 Status Moderator Last seen February 14, 2026 491
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

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