Compile Syntax Error - unsure whats wrong with Autofilter Label Macro

Hello,

Using MS Office 2003 on Mac & I am getting Compile Syntax Error and my Sub Name is being highlighted YELLOW & all those rows listing the Autofilter Actions are highlighted RED. It not even executing the first action, the column Insert.

Could someone please take a look & let me know if anything is obviously wrong - maybe I've been looking at it too long.

Greatly appreciate your help & insight.

Please Login or Register  to view this content.

Its just MS Excel for Mac. Files work the same between Mac and PC, same functionality for everything I've ever noticed, just thought I'd mention it in case.

If you look at it just like Excel on a PC, is there any reason why the Macro wouldn't even begin based on that code ? It is highlighting the Sub name Yellow like I have named it in the wrong format or something. And the Autofilter actions (which have always worked previously) are highlighted Red as if there is an error.

The Debugger is highlighting the $A$1 part of the range description & saying "List Seperator or )". Even when I reduce this Range to A1:CY200 it is still highlighting those Autofilter code lines Red & giving me the same error msg.

Very confused as I'm can't see what's wrong with code I have written.

Thanks, I will try this and let you know. Yes it is 2004 Office for Mac Student Teacher Edition. When I run it on my PC it works fine.

I have another problem which I will be raising in a separate post.