Macro for selecting a row

[Remko Campagne]

When I have selected a cell I want a macro to select the
entire row of the selcted cell.
Does someone know how to make a macro for that purpose?

Thanks in advance,
Remko

 

[J.E. McGimpsey]

One way:

Public Sub SelectRow()
ActiveCell.EntireRow.Select
End Sub

 

[cornishbloke]

try typing the following in the worksheet object in question:


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveCell.EntireRow.Select
End Sub