Error 1004 (unable to set the hidden property of the range class)

Hi,

I am having some issues with my excel marco that was being done by another colleague of mine ...

I have attached the command for the macro,

Please Login or Register  to view this content.

regards,
Alex

Hey Alex,

It looks like the error is in the Selection.AutoFilter step. There are all these columns selected and you call for an AutoFilter. AutoFilters are done with Tables so Excel is confused on what you want done.

You should set a breakpoint in the code and step through it one statement at a time to see which is giving the error, like I did. Then you need to examine what state the worksheet is in and if the VBA command makes any sense.

Here is a good source http://www.cpearson.com/excel/Debug.htm

I'd comment out that AutoFilter step and see what happens. You may be a star!