Hello my fellow Excel enthusiasts and experts!
I am in need of a macro that will analyze ActiveSheet and then select and delete entire rows that are implicated in that sheet's "Used Range" by this criteria:
- IF Cells, Range A2:U2 (and downwards) are all blank, delete row.
- IF Cells, Range C2:U2 (and downwards) are all blank, delete row.
- IF Cells, Range B2:U2 (and downwards) are all blank, delete row.
Cells in A2:I2 and downwards are "General" Format.
Cells in J2:U2 and downwards are .NumberFormat = "#,##0.00"
Also, there is an expanse of entirely empty rows (A:XFD) before rows with some population in A:U starts back up.
I have tried some things that aren't working and really appreciate any help. Thank you for considering.
Bookmarks