Hide rows in a named range based on cell value

Hello,

I am using the following code to hide rows. In the code, I am giving BeginRow = 12 and EndRow = 85 Which I would like to name it as Range 1 and
BeginRow = 87 & EndRow = 130 as Range 2. Using the named range "range 1" and "range 2", I would like to achieve the task ie., if cells in column 28 are zero, then hide the entire row.

Help plz.

Please Login or Register  to view this content.

Your code doesn't work? It should be doing as you asked.

Are there formulas in the cells in row 28? Are you looking for a value of 0 or an empty cell?

My code works. I want to modify the code for named range for future use(in case if any rows are added)

There are formulas in column 28. Not empty cell but I am looking for value "0".

That worked for me.

Thanks stnkynts.