Auto Filter Not Applying

[jvbeats]

using VBA in a code. I was using this same code for another workbook before and it worked fine.

Please Login or Register  to view this content.

The filter works, but it is not applied. after the macro is run, I need to click "OK" on the filter for it to apply. Any ideas?

[dilipandey]

The filter works, but it is not applied.

are you saying that you are not able to see the filter (small drop-down boxes) ?
If so, can you attach the sample file.?


Regards,
DILIPandey
<click on below * if this helps>

[jvbeats]

No I am able to see the filter, it is just not filtering (I can see all records). When I click the drop box filter box and click ok (without changing anything), the filter is applied. i cannot attach the file because there is sensitive data. If this does not clarify i will prepare an example.

maybe hard to understand because it is a strange error

[dilipandey]

Make sure you have "Applicable" in column L

If still facing issue, upload a sample file... thx

Regards,
DILIPandey
<click on below * if this helps>

[jvbeats]

the correct column is being filtered, but no, the filter does not apply (i see all records until I click "OK" under filter)

[dilipandey]

as i mentioned

If still facing issue, upload a sample file... thx

Regards,
DILIPandey
<click on below * if this helps>

[jvbeats]

solved. problem was that I was calculating the sheet right after the filter OOPS

[dilipandey]

like this :-

Please Login or Register  to view this content.

?


Regards,
DILIPandey
<click on below * if this helps>