Ed,
This WebPage does a fairly decent job of explaining For..Next loops
and For Each .. Next loops.
rw is a counter. You are looping backwards through each row and
setting the RowHeight property.
http://msdn.microsoft.com/library/en...structures.asp
HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
Paul, it works great in xl2000, too! (Needed an End If before Next rw.)
If I understand, I was trying to use rw as the object, instead as a property
of the Rows object? (Either way, I see I forgot to Dim it.)
Thanks much.
Ed