Suppress zero value rows

I have a worksheet that performs aged receivables for debtor and creditor ledgers.

Many have zero balances and therefore no aging; I would like to be able to run a macro that eliminates those rows.

Thanks

Dave

Hi Leith,

Balance is in column b

Rows 5 to 300

Thanks

Dave

Hi Leith

Thanks for that. When I run the macro it flags an error telling me that an object is required
in respect of:


Rng.Rows(r).Row.EntireRow.Delete

Kind regards

Dave

Originally Posted by Leith Ross

Hello daveglyn,

Here is the macro to remove the zero balance rows.

Please Login or Register  to view this content.

Hi Leith

Brilliant thank you!

Kind regards

Dave