Hide rows if have zero value in Multi-sheets

Closed
Issa Abu Hamameh - Apr 16, 2010 at 07:23 AM
rizvisa1
Posts
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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