Macro no longer works

[rkorinko]

Hi! So I created three macros to help with reporting for my company.

One sorts a field, another deletes unwanted columns, and the third double checks columns for answers--I work for a telecom polling firm.

It was working last week on my computer, and it still works on another computer at the office. However, I keep getting an error message when I try to run it.

The message is "Compile Error: Expected Function or Variable". The code is below, and bolded where it breaks down.--selection.Autofilter

Please Login or Register  to view this content.

What could be the rationale for the sudden breakdown? I was testing it on a file that I have tested with before without issue. I also tried a second file, and even restarted my computer. I am currently trying to write a fourth macro for counting responses and giving percentages, so while I don't need to have the perfectly cleaned data to do so it would be nice to have.

And how do I fix it?

Full disclaimer: I am relatively new to VBA and am still learning the basics so I apologize if the program is clunky.

[tigertiger]

put the text of your code into tab [CODE] by press # button on toolbar of "Quick Reply" because of the forum's rule, thanks

[rkorinko]

Please Login or Register  to view this content.

[alansidman]

Try changing these lines of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[rkorinko]

Fabulous! That worked, thanks a ton!