find most right visible cell on screen

[JasperD]

Hi guys and girls,

since my users work with different resolutions, I want to find a way to detect which cell is the most right cell they can see on their screen / window.
I don't care if it contains data - I just want to know which cell is the most right cell / column that the user can see in the current resolution / window size.

Is there a way to detect that?

Thanks for any help!

Jasper

[bbhockey]

Jasper,

I dont believe that there is a way, but if you can figure out the ranges of the rightmost column at differet resolutions, you will know which column will work for everyone. Sorry there isn't a solution to your problem

[JasperD]

Actually there is a way!

Please Login or Register  to view this content.

I adjusted it so that my shape is always at the right side of the screen, no matter the window size or which area is visible.
I put the code into Worksheet_SelectionChange & Workbook_WindowResize

Please Login or Register  to view this content.

Works like a charm!
(too bad I can't give rep to myself, haha!)

[Arkadi]

Nice one jasper!