Excel 2007 : Macro run-time error 1004

I am trying to create a macro to filter a very lengthy list of phone usage. I have successfully created the macro by recording the filter on column C (which returns only SMS message charges) and filtering by two phone numbers from column G. I then edited the macro to add the extra phone numbers I need to report on (34 phone numbers in total).

I have attached a small sample of my workbook and here's a snippet of my code:

Please Login or Register  to view this content.

When I run the macro, the filter on column C works okay but the filter on column G (highlighted in red) gives me run-time error 1004.

I can't find any info about this error code but I suspect it is related to the number of phone numbers I am trying to include in the filter. Could this be the case?

I would appreciate it if someone could point me in the right direction please.

You can only have two criteria for a given column in AutoFilter. Look in the user interface.

Thanks SHG. I'll work something else out.

Thanks for your suggestion Scaffdog. I won't have the time to try it for a few days, but I do appreciate you input. I'll get back to you if I have any further questions.