Previous Topic Next Topic

How do I select a row in a macro

Closed
Dreamer - Aug 13, 2010 at 05:18 PM
aquarelle Posts 7435 Status Moderator - 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 7435 Status Moderator 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

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

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

4 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
i need help bridge connection
olivea -
olivea -

2 responses