ExcelBanter - Select Row of Active Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select Row of Active Cell (https://www.excelbanter.com/excel-programming/340100-select-row-active-cell.html)

Michael Smith

Select Row of Active Cell

How would I select the row of the active cell....so if B6 is active, I
want to activate row 6.

TIA

*** Sent via Developersdex http://www.developersdex.com ***

Norman Jones

Select Row of Active Cell

Hi Michael,

Try:

ActiveCell.EntireRow.Select

---
Regards,
Norman

"Michael Smith" wrote in message
...
How would I select the row of the active cell....so if B6 is active, I
want to activate row 6.

TIA

*** Sent via Developersdex http://www.developersdex.com ***

All times are GMT +1. The time now is 06:16 AM.