Display margin settings

[JudyHNM]

I am using Excel 2016, Windows 10. How do I display/show the margin settings of the current worksheet, using VBA.

Thanks, Judy

 

[Andrew Poulsom]

Welcome to MrExcel.

Example:

    With ActiveSheet.PageSetup
        MsgBox "Left margin is: " & .LeftMargin
    End With

Other properties are RightMargin, TopMargin, BottomMargin, HeaderMargin and FooterMargin.

 

[JudyHNM]

Welcome to MrExcel.

Example:

    With ActiveSheet.PageSetup
        MsgBox "Left margin is: " & .LeftMargin
    End With

Other properties are RightMargin, TopMargin, BottomMargin, HeaderMargin and FooterMargin.

That's perfect with one little exception -- how do I get it to display the result in inches!

Thanks, Judy

 

[Andrew Poulsom]

A Point is 1/72 of an inch.

 

[JudyHNM]

A Point is 1/72 of an inch.

Thanks for your help.

Judy