![]() |
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?? |
All times are GMT +1. The time now is 08:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com