Filtering on cell values within macros

[dirtydan86]

Hi,

I am trying to use a macro to filter on various cell values, it would seem to work sometimes but i find other times it doesnt seem to select the filter... when i go back after the macro has run and look on the filter options the cell values are entered in criteria... but dont seem to have selected OK?

Ie if i run macro values are present on filter but no filter results appear... if i select OK on reselcting the filter (after the macro has run) the results appear?

Code used

Please Login or Register  to view this content.

Any idea how i can make sure the macro selects OK to display results?

[arlu1201]

What are the values in AB1 and AD1?