ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What is the Visual Basic command to select an entire row in Excel. (https://www.excelbanter.com/excel-programming/310868-re-what-visual-basic-command-select-entire-row-excel.html)

Ron de Bruin

What is the Visual Basic command to select an entire row in Excel.
 
Hi Sahja

You can use this for the activecell row
ActiveCell.EntireRow.Select

Or this for row 15
Range("A15").EntireRow.Select


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com