Excel Row Deletion Based on Fill
Posted on 2014-12-09
Oh great and knowledgeable people of EE:
I want to add a little bit of code to an existing Excel macro that will do the following.
1) Select all content.
2) Review each line individually to determine if the row contains a cell with the default gold fill.
3) If the row does NOT contain a cell with gold fill, the row should be deleted.
4) The code then moves through the remaining content, repeating the deletion process for all rows that do not contain a cell with gold fill.
The end result is that only rows that contain at least one cell with gold fill remain.
As always, your assistance is greatly appreciated.