VBA Code for Hiding Rows with Zero Values

X

XLNut1958

Joined
Mar 22, 2007
Messages
4
Reaction score
0
Greetings,

I wonder if anyone has a macro for hiding rows with zero values. It would have to look through a range in a column and then if the cell had a zero value, hide the row the cell was in.

I tried to use the AutoFilter and built a macro that selected the "blanks", but the macro won't run with the sheet protected.

Any suggestions would be most appreciated.

~SK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for Hiding Rows with Zero Values 0
Automatically hiding rows with specific values 3
Hide Rows if all values are zero 5
Hiding rows with zero values 2
Hiding Rows-Macro or Autofilter 4
Select rows with visible data 0
hiding rows containing formulas which return zero values 3
Need Help hiding rows 0

Top