![]() you can give any name for this dataset, in this example we will name it customer. This macro have 2 parameters, the first is a dataset that retrieve the values. Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Here we are using the macros sclookup with this macro can retrieve database records running a SELECT on any table in the database. MsgBox "The current left margin is " & marginInches & " inches" marginInches = Worksheets("Sheet1").PageSetup.LeftMargin / _ This example displays the current left-margin setting for Sheet1. Worksheets("Sheet1").PageSetup.LeftMargin = _ This example sets the left margin of Sheet1 to 2 centimeters. ![]() ![]() This example sets the left margin of Sheet1 to 1.5 inches. Use either the InchesToPoints method or the CentimetersToPoints method to do the conversion. SyntaxĮxpression A variable that represents a PageSetup object. ![]() Returns or sets the size of the left margin, in points. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |