Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This example copied from the help of the WorkSheet.Calculate event works well:
Private Sub Worksheet_Calculate() Columns("A:F").AutoFit End Sub But it loops forever when I replace it with: Private Sub Worksheet_Calculate() Rows("10:20").AutoFit End Sub It looks like resizing the rows (even rows outside the UsedRange) causes the volatile functions to be calculated, while resizing the columns doesn't. Does it make sense? How can I resize the rows after a calculation? Thanks, Stefano |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rows().AutoFit starts a calculation, but Columns().AutoFit doesn't | Excel Programming | |||
Autofit (Columns.EntireColumn.AutoFit) does not work | Excel Discussion (Misc queries) | |||
Autofit Columns | Excel Discussion (Misc queries) | |||
Autofit some columns | Excel Programming | |||
Columns.Autofit not doing what I want | Excel Programming |