I have a hard time figuring out what that functionality is. If I run this
code from the example:

Sub BB()
With ActiveWindow
lWinWidth = _
.PointsToScreenPixelsX(.Selection.Width)
lWinHeight = _
.PointsToScreenPixelsY(.Selection.Height)
End With
Cells(1, 1).Value = lWinWidth
Cells(2, 1).Value = lWinHeight
End Sub

the help claims it give the height and width in pixels, but I get different
numbers if I move the window around the screen without changing either the
selection or the zoom.

--
Regards,
Tom Ogilvy


"MRay" wrote in message
...
Since Excel97 does not support the .PointsToScreenPixelsY and
.PointsToScreenPixelsX method of a Window object, how does one emulate
this
functionality in 97?