autofilter does not work when i make this change

[dmcgov]

i get different results when i run this bit of code:

Please Login or Register  to view this content.

the above code works as expected. but when i make this change, the results get skewed

Please Login or Register  to view this content.

how can i fix my code so that it works?

[PCI]

Take care when uing
Sheets("estimating1").Range("B66:J432").AutoFilter
Perhaps you are not in sheet "Sheets("estimating1")" , what is the active sheet?

[dmcgov]

i fixed it the following way:

Please Login or Register  to view this content.

[PCI]

Hummm, not sure it works 100%
I suggest to add

Please Login or Register  to view this content.

It is not very nice but should work immediately

[dmcgov]

thanks PCI, but i got it working without the select statement.

appreciate the help