Remove empty rows from a range

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Albert Browne" <albert.browne@xxxxxxxxxxxx>
Date: Tue, 14 Oct 2008 19:20:15 +0100

Hi,

I have a range on a work*** E7:M106. When certain conditions are met a row in the range is moved to another work***.
Alternate rows are formatted with a different colour which needs to be preserved. What would be the best way to move all the other rows up to close this gap?

Thanks,

Albert

.

Follow-Ups:
- RE: Remove empty rows from a range
  - From: RyanH

Prev by Date: RE: Most efficient way to loop through a folder and find all the XLS f
Next by Date: Re: Return the Module Location & Sub Procedure Name on Error
Previous by thread: disable workbook
Next by thread: RE: Remove empty rows from a range
Index(es):
- Date
- Thread