ExcelBanter - How do I hide or unhide zero value columns/rows USING A MACRO?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I hide or unhide zero value columns/rows USING A MACRO? (https://www.excelbanter.com/excel-discussion-misc-queries/66786-how-do-i-hide-unhide-zero-value-columns-rows-using-macro.html)

paul

How do I hide or unhide zero value columns/rows USING A MACRO?

Dave Peterson

How do I hide or unhide zero value columns/rows USING A MACRO?

Apply data|filter|autofilter
record a macro when you show the rows that have a value not equal to 0.

And you'll your code.

paul wrote:

--

Dave Peterson

All times are GMT +1. The time now is 07:23 AM.