Thread: Autofit row height in only some rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JStiehl JStiehl is offline
external usenet poster
  
Posts: 35
Default Autofit row height in only some rows
Is it possible to change this macro to only autofit the row height on rows
254-332 in the workbook? I am using this macro:

Option Explicit
Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
Application.EnableEvents = False
Sh.Rows.AutoFit
Sh.Rows("1.33").AutoFit
Application.EnableEvents = True
EndSub

Thanks in advance for your help.
Reply With QuoteReply With Quote