Why is this VBA code causing rows to unhide?

  • Hi Everyone,

    For some reason this code is causing all rows to unhide. It does exactly what I need besides that little hiccup. Should I use a different method? Thanks in advance for any help.

  • If the rows were being hidden as a result of using one or more filter conditions on the V40:AF417 range then you are completely clearing that filter with the following code:

    Code
    1. .AutoFilter

    which in turn removes any rows previously hidden by the filter selection