Ugly slow code....

**Slyone2** · 08-15-2010, 04:11 PM

Works, but really slow.....

Please Login or Register  to view this content.

I tried Array it didnt work for me, Any ideas for faster cleaner code?

**snb** · 08-15-2010, 04:21 PM

Please Login or Register  to view this content.

**shg** · 08-15-2010, 04:24 PM

Please Login or Register  to view this content.

**Slyone2** · 08-15-2010, 04:46 PM

thanks, its didnt help improve .....slowness.....loooking for source......

**Slyone2** · 08-15-2010, 05:14 PM

The prob is $1:200 reference back to the sheets just changed.
Even, insert/ delete should keep range intact.

Excel slows. iguess checking everything.

Any thoughts?

**Slyone2** · 08-16-2010, 07:36 PM

any other ideas?

**TryToExcel** · 08-16-2010, 08:02 PM

SlyOne2,

When you say "slow" what time frame are talking about (10 seconds, longer?) so we can have an idea what we are trying to improve upon. Also, how many average columns and rows are there per sheet? Do you have a lot of formulas? As you see "snb" turned off the calculations to speed things up. Give us more to go on.

Danny
Or just an average are

**Slyone2** · 08-16-2010, 08:13 PM

Timing:
When I comment out /loop around my ugly or Shg code it take 25 seconds.....
When use my ugly or Shg code it take 3-4 minutes...
Rows start from 4 goto 200 per sheets. columns around 200 per sheets.

The only thing different is deleting and insert rows, which seems to throw Hlookup into tizzy.
The sheets are tables, since old rows in tables are not used, I want to delete to keep xls small.

Hlookup use $1:$200 to find row.