Forum Discussion
AutoFilter method throws error in VBA
I need to help a user group with a spreadsheet. The person who made it left. Can someone assist with the following code? It fails on the line "PEntry.AutoFilter" with "AutoFilter method of Range clas...
First thing first, the autofilter criteria is taken from EntryForm sheet E6 cell. You can manually copty the whole content of the cell (sometimes there may be some invisible chars there) and try a manuel filter on said range, Client Directory columns A:E. the filter condition applies to column E. If it does then we need to check other options