Delete Rows

sassriverrat

Well-known Member
Joined
Oct 4, 2018
Messages
618
I need a macro that checks column G for either a 0 or 1 and then deletes the row if the cell equals 0. I have a huge array of 1200 cells to run this through.
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,273
Office Version
365
Platform
Windows
Why not just use autofilter?
Filter for 0 & delete the rows.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,273
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,100,178
Messages
5,472,967
Members
406,842
Latest member
Nay83

This Week's Hot Topics

Top