autofilter issue

Hello,

I am using the following vba to filter some data. Now this code correctly applies the criteria, but does not appear to correctly apply the filter.

Please Login or Register  to view this content.

When i click the dropdown and select Date Filters > Customer Filter. the correct criteria is added. Now if I hit OK at this point the sheet refreshes and the filter works, but initially it doesn't.

Im thinking I'm missing a very simple step here, but I just can't spot it.

Cheers for any help

If the finalrow is probably defined and assigned a value.

Please Login or Register  to view this content.

Best to attach a sample book you are working on.

Sorry thats a mistake in my variable names

it should probably read as FinalColumn and RowCount

Please Login or Register  to view this content.

What are FinalColumn and RowCount?

If they are variable, Where are declared and assigned values?


May try one of these lines

Please Login or Register  to view this content.

They are declared I just didn't list them in this snippet. I dont think thats the issue I'm having as the range is being correctly defined.

Please Login or Register  to view this content.

But I'm still having the issue where the correct criteria are added into the custom filter box but the spreadsheet does not reflect the filter until i open the box and hit OK

snip.JPG

As I said, it would have easier to resolve the issue you have if you had attached the sample.
We will go around the circle.
My guess is you have recorded a macro to filter a data and it works, but when you try to tweak to adjust the rows and columns, you get an error. Is this right?

I don't get an error as such, as I said it inserts all the correct criteria and the code fully executes but the data just isnt correctly filtered until i open the custom filter dialog box and hit OK

But yes, If I enter all the criteria manually it does work.

Thanks for your help.

I think it was because I was inserting an extra space at the end of the range with & ""

Please Login or Register  to view this content.

Seems to be working now......