Filtering in Recording a Macro

Hi, I am trying to record a macro and part of it requires changing a filter. I have tried to run this before and the macro always errors when I go to change the filter.

.
Strange ... I just tested here (out of curiosity). It works well here.

I'm using Excel 2007