ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Select a Cell - Move Row to the Top of the screen (https://www.excelbanter.com/excel-programming/341067-select-cell-move-row-top-screen.html)

CRayF

Select a Cell - Move Row to the Top of the screen
 
If I click on a cell can I make that row come to the top of the screen?

There are a set of of rows controled together. Is only part of them are
showing, I'd like to click on a cell at the top of the group to make that set
of rows to come to the top of the screen.


Tom Ogilvy

Select a Cell - Move Row to the Top of the screen
 
Use the selection change event to detect you have clicked there. Then use
the

ActiveWindow.ScrollRow to put it at the top of the window.

--
Regards,
Tom Ogilvy

"CRayF" wrote in message
...
If I click on a cell can I make that row come to the top of the screen?

There are a set of of rows controled together. Is only part of them are
showing, I'd like to click on a cell at the top of the group to make that

set
of rows to come to the top of the screen.




CRayF

Select a Cell - Move Row to the Top of the screen
 
thanks


All times are GMT +1. The time now is 07:24 PM.

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