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

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

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/