Compile Error: Sub or Function not defined

Hey all,

I have a macro that filters out data using auto filter. Problem is once everything is complete, I only want to keep the visible cells and destroy everything else. So I added a For Each In loopm to iterate through active cells and set their auto filter mode to false, which hopefully removes any filtering. Unfortunately it gives me a compire error highlighting the text "specialCell":

Please Login or Register  to view this content.

Thanks for any response.

Why don't you use something like the following? ActiveSheet.AutoFilterMode = False

Also, if you are trying to just keep the filtered data, why don't you copy visible cells after the filter and then paste it into a new sheet and delete the old one?

Because I'm trying to put it all together in a macro. And if I copy and paste to new document, then it won't work with macro.

I don't mean a new document, just add a new Sheet (tab) in your workbook and paste your values in there.