ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What's the corrent event? (https://www.excelbanter.com/excel-programming/338526-whats-corrent-event.html)

OKLover[_2_]

What's the corrent event?
 
What's the corrent event for a worksheet window scrolled?
And how to detect the current visible window top-right cell's adress?


Tom Ogilvy

What's the corrent event?
 
There is no event for that.

Dim rng as Range
set rng = activewindow.VisibleRange.Rows(1).Cells
msgbox rng(1,rng.columns.count).Address


"OKLover" wrote in message
...
What's the corrent event for a worksheet window scrolled?
And how to detect the current visible window top-right cell's adress?





All times are GMT +1. The time now is 05:30 PM.

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