Excel Row height settings - pixels to inches

[emcc]

Is there a way to change the row height measure from pixels to inches in Excel 2000?

 

[SkipVought]

Hi,

There are 72 pixels per inch...

Go figure ;-) Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

Here's a procedure that will do what you want I think...

Sub RowHeightInches()
'
' Macro1 Macro
' Macro recorded 3/17/2003 by Skip Metzger
'

'
    nbr = InputBox("Row of how many inches?")
    If Not IsNumeric(nbr) Then Exit Sub
    Selection.RowHeight = 72 * nbr
End Sub

Hope this helps Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[SkipVought]

sorry....


I forgot EntireRow...

Sub RowHeightInches()
'
' Macro1 Macro
' Macro recorded 3/17/2003 by Skip Metzger
'

'
    nbr = InputBox("Row of how many inches?")
    If Not IsNumeric(nbr) Then Exit Sub
    Selection.EntireRow.RowHeight = 72 * nbr
End Sub

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com