Long macro process time for deleting rows

[WoolyFox]

Hi there,

I need some help with shorting a macro run time to prevent Excel crashing. I am running on 64-bit on a newish i7 with 16Gb RAM so I don't think it's a hardware issue.

The macro I am running is below.

Please Login or Register  to view this content.

Currently the script takes nearly an hour to run and frequently hangs or stops Excel responding. I want to find a way to shorten the process such as only removing zeros from the rows which have fields instead of look at all rows up to 20000. As the data set varies in size this arbitrary row 20000 as we don't anticipate row usage to go above this level for the time being.

If someone can give me some pointers as to how to speed this up that would be great.

[Fluff13]

How about

Please Login or Register  to view this content.

[WoolyFox]

Thanks! This works perfectly dropping the run time from 30 minutes to 30 seconds. I am only just starting out with VBA so still learning about these functions. Thanks again for this script.

[Fluff13]

You're welcome & thanks for the feedback