Macro for selecting a row
 

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

Macro for selecting a row
 

One way:

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

In article ,
"Remko Campagne" wrote:

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

Macro for selecting a row
 

try typing the following in the worksheet object in question:


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


---
Message posted from http://www.ExcelForum.com/