How do I select a row in a macro

Closed

Dreamer - Aug 13, 2010 at 05:18 PM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - 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

How do I select a row in a macro
Vba select case like - Guide
Spell number in excel without macro - Guide
Saints row 2 cheats - Guide
Automatically run a macro when opening a worksheet - Guide
How to delete a row in a table in word - Guide

1 response

Answer 1 / 1

aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 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?

Code for macro that conditionally inserts rows

Can't select text

Similar discussions

Subscribe To Our Newsletter!