Thread: Autofit row height in only some rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
p45cal[_278_] p45cal[_278_] is offline
external usenet poster
  
Posts: 1
Default Autofit row height in only some rows

VBA Code:
--------------------


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


?


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=203770

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote