Macro Slow After Using Filter

[FallingDown]

Hi all

My worksheet_change Macro is running smoothly, until I filter a data.
Even when I remove all filters, the macro will take a minute to run (whereas it is instantly otherwhise)

Anyone has any idea what the reason could be for this?

[:) Sixthsense :)]

Please share your code.. if possible with a sample workbook

[FallingDown]

Please Login or Register  to view this content.

I am afraid I cannot share a sample workbook

[:) Sixthsense :)]

I am not seeing any filter in your code…

Here is the little bit fine tuned version of code…

Please Login or Register  to view this content.

[FallingDown]

HI

Many thanks for your help.

Yes, there's no filter set in the code. It's only on the worksheet.
The thing is when I filter by "abc" (or whatever I filter by), then unfilter, the macro takes ages to run - I don't understand how it could have a influence on the code

[FallingDown]

Hi Sixthsense

I just changed the part about col. width to

Please Login or Register  to view this content.

[:) Sixthsense :)]

Just remove the screen updating turn off and On code and check…

[FallingDown]

Hi there

Are you referring to the macro running slow after filtering?

[:) Sixthsense :)]

Just remove the Application.ScreenUpdating = False & Application.ScreenUpdating = True completely from your code and check...

[FallingDown]

Hi sixthsense

No success by removing it

However, I spotted the part which makes it so slow after filtering - is there a way to improve the coding of this?

Please Login or Register  to view this content.

Thanks

FD

[:) Sixthsense :)]

Check the below code...

Please Login or Register  to view this content.