expression.PointsToScreenPixelsX(Points)
expression Required. An expression that returns a Window object.
Points Required Long. The number of pixels to add to this method's result.
Remarks
Although the name of this method suggests that it will convert point values to screen pixel values, it actually performs the action described above using only pixel values. For the PointsToScreenPixelsX method, this value will vary by a fixed amount (24 pixels) depending on whether row headers are turned on.
Example
This example returns 25 when row headers are turned on, and returns 1 when row headers are turned off.
Sub Window_OnLoad()
MsgBox Spreadsheet1.ActiveWindow.PointsToScreenPixelsX(0)
End Sub