Delete Visibile Rows on Filtered Criteria

Hullo You Beautiful people,

This is driving me insane and I can't work out why Excel is struggling?

The below macro looks for the word HAUTH in column U and should delete the special visible rows. It does what it says on the tin but it takes a fricking' age

Please Login or Register  to view this content.

It appears to be the:

Please Login or Register  to view this content.

that is taking an age? Sometimes over 3 minutes.

Can anybody suggest anything to speed this up as I have a lot of macro's set up the same way and the file can take 20 minutes just deleting stuff that isn't needed.

Help!!

Can anybody help?

Hi Sintek,

Apologies for the delay only just got back to what I was working on.

The code you have kindly supplied still isn't working speed wise.

Below is my immediate window with debug start and end

Please Login or Register  to view this content.

Which is still running at 2 minutes.

I should have said that the amount of HAUTH lines can exceed 1800 lines at any one time.

This has really got me perplexed?

Ok, Give me 10 to clean it up and I will upload

I think I have just worked it out... the file is on a network drive and when I am running the macro through the shared folder it is taking an age. When I do it from my desktop it is instant.

Well this is a kick in the teeth

Ok, maybe it isn't what I thought.

When I run with the rest of my macro's this code takes an age. So I shut down excel reopen it and run the macro seperately and it is instant. So I must be clogging something up in the background when running all the macros?

Any ideas?

I have dim'd alot outside of the macro's do you think this could be causing the slow down.

Please Login or Register  to view this content.

Then started setting in the macro's.

Looks like I may have to revisit all my other macros