View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobFMS RobFMS is offline
external usenet poster
 
Posts: 4
Default What is the Visual Basic command to select an entire row in Excel.

Try:

ActiveSheet.Range(Range).EntireRow.Select

Where Range is a cell address on the row you want to select.
If row 3 is what you wanted selected, then range can be set as "A3", "D3",
etc.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Sahja" wrote in message
...
When I use the command Rows.EntireRow.Select in Visual Basic to select a
single row in an Excel spreadsheet it selects all the rows in the
spreadsheet. Is there another command that will select a single row??