Loop through range, Autofit height
What are your parameters for the range named "AutoFit", which, by the way,
is a bad practice to use reserved words for names and variables.
"John" wrote in message
...
This is a sub I made to loop through a range and autofit row height of
each row:
Sub AutoHeight()
Dim c As Range
For Each c In Sheet1.Range("AutoFit")
Rows.AutoFit
Next c
End Sub
The macro just keeps running and running. What;'s wrong with my sub?
|