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/310873-re-what-visual-basic-command-select-entire-row-excel.html)

Paul B[_8_]

What is the Visual Basic command to select an entire row in Excel.
 
Sahja, how about

ActiveCell.EntireRow.Select
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

"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:25 AM.

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