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

Jorge Rodrigues

What is the Visual Basic command to select an entire row in Excel.
 
Perhaps
Columns("A:A").Select
Jorge


"Sahja" escreveu na mensagem
...
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??




Jorge Rodrigues

What is the Visual Basic command to select an entire row in Excel.
 
Oops.. Typo:
Rows("1:1").Select
Joree
"Jorge Rodrigues" escreveu na mensagem
...
Perhaps
Columns("A:A").Select
Jorge


"Sahja" escreveu na mensagem
...
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 10:21 AM.

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