Prev: Bug Report: VBA runtime Access Violation
Next: File folder info. in Excel workbook?
From: JStiehl on 19 May 2010 07:54
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.
From: p45cal on 19 May 2010 08:10

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/showthread.php?t=203770

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Bug Report: VBA runtime Access Violation
Next: File folder info. in Excel workbook?