Cell Height & Width in Inches 2

[theDabster]

Folks,
Is it possible to format cell height and width based on
inches. It looks like it's based on picas. I have searched Excel's Help as well as on this forum, but no luck (or else I missed it). I would like to be able to make a cell (as an example) .25 inches high by 1.45 inches wide. Any help will be appreciated.

Dave

 

[SkipVought]

Hi,

Why not use Inches to Points? Help states...

InchesToPoints Method
See Also Applies To Example Specifics 
Converts a measurement from inches to points.

expression.InchesToPoints(Inches)

expression   Required. An expression that returns an Application object.

Inches   Required Double. Specifies the inch value to be converted to points.

Example
This example sets the left margin of Sheet1 to 2.5 inches.

Worksheets("Sheet1").PageSetup.LeftMargin = _
        Application.InchesToPoints(2.5)

Hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[BlueMonkey]

If it helps (and if I recall correctly, there are)

72 pts to an inch
24 pts to a cm Blue Monkey