Thread: Row Sizing
View Single Post
  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

I think you'll need a macro to assure the minimum height.

Option Explicit
Sub testme()

Dim myRowHeight As Double
Dim myRow As Range
Dim minHeight As Double

minHeight = 16.5

For Each myRow In ActiveSheet.UsedRange.Rows
myRow.AutoFit
If myRow.RowHeight < minHeight Then
myRow.RowHeight = minHeight
End If
Next myRow

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Mike@ACM wrote:

Similar to property within a table in Word where you can specify the height
as "at least"... Within Excel is it possible to set a row(s) to begin as a
set size (i.e.: 0.5") and auto fit if text requires a larger space?

Perhaps a macro might be able to what I am asking, does anyone have a
suggestion or code that works?

Thanks in adavance for your assistance.
Mike


--

Dave Peterson