Application.CentimetersToPoints Method

  • Article
Excel Developer Reference

Converts a measurement from centimeters to points (one point equals 0.035 centimeters).

Syntax

expression.CentimetersToPoints(Centimeters)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Centimeters Required Double Specifies the centimeter value to be converted to points.

Return Value
Double

Example

This example sets the left margin of Sheet1 to 5 centimeters.

Visual Basic for Applications 
  Worksheets("Sheet1").PageSetup.LeftMargin = _
        Application.CentimetersToPoints(5)

See Also