Hide rows if have zero value in Multi-sheets

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month