Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help me please understand this Visual Basic command | Excel Discussion (Misc queries) | |||
VISUAL BASIC COMMAND TO MOVE CURSER DOWN ONE CELL | Excel Worksheet Functions | |||
What is the Visual Basic command to select an entire row in Excel. | Excel Programming | |||
Problems in Visual Basic Editior, In search of a command | Excel Programming | |||
visual basic command in a cell?? | Excel Programming |