Macro running slow

**rz6657** · 11-14-2012, 02:23 PM

I created a macro but it runs slow. Please can someone review the macro and recommend something?

The macro is in module 1 in the attached file. Thanks.

**HaHoBe** · 11-14-2012, 02:34 PM

Hi, vrz6657,

using the macro recorder gives code that needs to be reworked.

Try this one:

Please Login or Register  to view this content.

Ciao,
Holger

**rz6657** · 11-14-2012, 03:10 PM

Holger - thanks for your feedback. That is one of my macros that has "All" in both instances. My other has if ITO = ITO if not = NITO. Will that change you did also work for that other macro?

**HaHoBe** · 11-14-2012, 04:42 PM

Hi, rz6657,

the change I made is just for the case that one item will be filled in. If that differs you need to loop through the range just like you did in the original code or maybe think about using the Autofilter and work on the visible cells thereafter.

Ciao,
Holger