Hiding columns using a macro after rows have been filtered using a macro

Hi,

This is the error I get "Unable to set the Hidden property of the Range class"

Thanks


Hi,

Hope some can help me. I have a spread sheet in which I have created a macro to filter a number of rows. When I don't filter the rows the column macro works fine ( hides three columns with "plan" data). When I filter the rows using a selection criteria and then try and hide the same columns it does not work. Can some one please advise how I can over come this problem.

Thank you