Multiple Autofilters - VBA

[teshiburu1988]

Good Morning All,

slight problem here with 2 autofilters i am using, they are both initiated using VBA code and criteria on a control sheet however it appears that one is cancelling the other out, for example i manage to get my date filtered but no times, or if i alternate the run order i get times filtered but no dates i have enclosed the code below if anyone can see what i have done wrong

many thanks in advance

Teshi

Please Login or Register  to view this content.

[teshiburu1988]

Can anyone offer any insight on this issue? it would be greatly appreciated been trying to get it right all afternoon

would be much appreciated

[teshiburu1988]

Can anyone offer any assitance with this? if i have not been clear can enough please explain what needs to be known

[teshiburu1988]

Sorry to bump this but still no joy, can anyone assit?

[teshiburu1988]

I have now cross posted this thread on MrExcel

Mr Excel Post

[shg]

Post a workbook.

[teshiburu1988]

shg,

thankyou for offering to take a look, i have highlighted the regions on the command sheet that should contain my criteria and have unhidden the sheet on which the data i want filtered resides,

thanks again

Teshi...

[teshiburu1988]

Sorry about double post, took ages to upload for some reason... gave up with previous post thought i would time out

here it is

[shg]

Try this:

Please Login or Register  to view this content.

[teshiburu1988]

shg,

Thank-you so much that is perfect, i know the code works but could you explain what caused the issue for myself in the first place?

Teshi...

[shg]

I don't do much with filtering but ...

A sheet can only have one autofilter, and this line was turning it off after you set the first filter:

Please Login or Register  to view this content.