View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default "Each Row from there to here"?

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