very slow macro (delete blank rows)

**Danielle22** · 07-19-2013, 03:09 AM

Hi all,

I use this Macro:

Please Login or Register  to view this content.

This code takes very long (20 minutes).

is there a possibility to speed up this code?

Regards,

Danielle

**Pepe Le Mokko** · 07-19-2013, 03:17 AM

Not a VBA man, but filtering then deleting with VBA should be much faster

**zbor** · 07-19-2013, 03:20 AM

Will this help for a start:

Please Login or Register  to view this content.

**Danielle22** · 07-19-2013, 04:13 AM

Thanks!

I use a filter now

Re: very slow macro (delete blank rows)