PointsToScreenPixels giving unexpected results for range width

That's referencing column L, not column I. Is that it?

WBD

It's telling you where X points from the left hand side of the workbook window is as a screen co-ordinate, therefore it will alter if you move the window.

Originally Posted by rorya

It's telling you where X points from the left hand side of the workbook window is as a screen co-ordinate, therefore it will alter if you move the window.

I don't think this is right. On a new workbook, Range("A1").Width and Range("Z1").Width both return the same value for me i.e. the width of the range.

WBD

Huh? I'm talking about ActiveWindow.PointsToScreenPixelsX. If you do:

Please Login or Register  to view this content.

and move the window around, you should see different values, which are the X screen position of the first point of the workbook window.

Trying to put those together my understanding was it would give me the width in pixels of A1:L1 (sorry about lower case there).

If it is the case that it gives me the screen position rather than the pixel width if I take the same number as the left side co-ordinate of a VBA userform when it displays it does not land at the same point ie in this case not where L1 is.. Is it a different measurement for where the userform.left?

Originally Posted by rorya

Huh? I'm talking about ActiveWindow.PointsToScreenPixelsX. If you do:

Please Login or Register  to view this content.

and move the window around, you should see different values, which are the X screen position of the first point of the workbook window.

Yes. Sorry. I was reading your reply incorrectly. What's odd is using this function on something that's returning a width since essentially this is function to return the screen position of a point on the active window. It would make more sense to use:

Please Login or Register  to view this content.

That would return the X screen coordinate of the A1 cell. If you want to know the actual width in pixels of the range perhaps you need:

Please Login or Register  to view this content.

It's all a bit confusing I guess.

WBD

If memory serves, the Left property of a userform is given in points, not pixels.