Hide rows if have zero value in Multi-sheets

Closed
Issa Abu Hamameh - Apr 16, 2010 at 07:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 16, 2010 at 07:35 AM
Please note that I don't want to make filtering, what I need is to Hide a range of rows if they have zero value in specific columns in Multiple sheets. So how can I make a macro (or one command buttomn) in the Excelsheet that: I can hide the entire rows if a cell valuen has a zero value in multiplesheets. Of course, the location of the column and the cells are the same on every sheet.

Thank you in advance
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 16, 2010 at 07:35 AM
you asked this question few days back and was answered then. Do a search for it on the forum and you will find it.
1