Deleting rows based on a cell value (update)
This is an update to the previous video ( • Deleting rows based on a cell value , which provided guidance to users deleting rows based on empty or zero values.
We will use the original format of data, which will overcome an oversight that the original macro had.
In this example, this updated macro will be able to delete rows of data, even if they are at the bottom of the data.
Let's compose our revised macro. We will call this macro, deleteZeroRows