Thread: Row Height
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hyyfte hyyfte is offline
external usenet poster
 
Posts: 1
Default Row Height

Someone please help me with this code. I'm trying to write a macro t
autosize an undetermined amount of rows and set a minimum row height o
33.75. Any ideas? I keep stepping through my code and it wil
autosize, but then changes all the rows to 33.75, instead of leavin
the ones alone that have to be larger. Thanks.



Sub Rows()

Selection.Rows.AutoFit

If RowHeight < 33.75 Then
Selection.RowHeight = 33.75
End If

End Su

--
Message posted from http://www.ExcelForum.com