Autofit row height in only some rows

JStiehl

Guest

Posts: n/a

19th May 2010

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.

« formula needed to extract data from another file | Runtime error 1004 application-defined or object-defined error »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Set a minimum row height a the same time with autofit row height	Julie B	Microsoft Excel New Users	1	29th Apr 2010 11:11 PM
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't	Stefano	Microsoft Excel Programming	1	30th Nov 2009 05:01 PM
RE: Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't	Mike H	Microsoft Excel Programming	0	25th Nov 2009 04:31 PM
Autofit Height of Rows too High	Kris	Microsoft Excel Misc	2	6th Feb 2009 04:18 PM
AutoFit Row Height	PWS	Microsoft Excel Programming	5	19th Feb 2007 05:00 PM