last visible row

**OJNS** · 10-29-2017, 05:29 AM

hi
Whenever a table cell is selected a tooltip image is displayed with some more information.
The image is positioned next to the selected cell as follows

Please Login or Register  to view this content.

The image top is set to the cell top.

However, there are cases in which the image bottom exceeds the bottom of the screen.
In such a case I want to position the image above the cell so that that the image bottom will be as the cell bottom.

The problem is to identify these cases.

I checked ActiveWindow.Bottom value, but this value returns "higher" value on the screen (around 4-5 rows above the last row).
I don't really understand what this value is.

I thought about finding the last visible row, by looping rows, and check its bottom value.
But I cant find a way to check whether a row is actually visible on screen (because of scrolling and as a result of filtering - Hidden property )

Please advise

tx

**Keebellah** · 10-29-2017, 07:04 AM

I understand what you want but it's not something (IMHO) that is simple, but the problem is the row number is not related to the position on screen, it has to be converted to pixels something like 17 pixel per row, so if you are at row 20 the pixels is 20 * row number but then you need to know the bottom of the active window which is the height which is also in pixels and your bottom row would have to be dispaked at Height - image top
Something like that you can google and you will find similar ideas
Hope this pints you in the right direction