One way would be to filter the list to display the zero values. Then
delete those rows and unfilter the list.
If you want it to be automatic, then a simple macro to perform those
steps would do the trick.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.