LENGTHY VBA Runtime

[excellenthelp]

Excellers,

I am wondering why this VBA code is taking sooooo long to perform? Is there a way to run it quicker? I am suspecting it loops too many times.

Help....?

Please Login or Register  to view this content.

[HaHoBe]

Hi, excellenthelp,

maybe the Autofilter and action to visible rows may speed that procedure up although I think best practise could be the use of the Advanced Filter to only get the data wantd and perform further action to that range.

Ciao,
Holger

[Norie]

Have you checked what ActiveSheet.UsedRange.Row.Count is returning?

Using UsedRange to count the no of rows can sometimes give misleading results.

[excellenthelp]

Ahh, Norie.

After checking, the results came as "24462". That is 24,462 rows. It could go up to 45,000 rows.

How could this be rewritten to speed up the macro?

[excellenthelp]

This thread is being Bumped.

[Norie]

Have you tried filtering out all the rows you don't want and then copying the rest to another sheet?

[excellenthelp]

This has to be done via VBA. How can I filter it with around 45,000 rows? What is the VBA code name for it and where may I learn the code?

[Norie]

Eh, I didn't mean do it manually.

IThere are 2 types of filtering in Excel, AutoFilter and Advanced Filter both of which you'll find on the Data tab.

In VBA they are called AutoFilter and AdvancedFilter.

[excellenthelp]

Okay, thanks. I will play around with it and see what I come up.

Thanks so much, Norie!