Excel 2007 : Macro - loop slows down

**shg** · 05-20-2010, 10:52 AM

Possibly something like:

ThisWorkbook.Sheets("MGN Detail").Range("ERCopyRange").Calculate

That exact syntax will work. It doesn't turn calculation back on for that range, but it does calculate it once with all dependencies. However, what you'd actually do, for the reasons previously described, is

rERC.Calculate

See Help for the Calculate method.

**IALTO** · 05-20-2010, 11:44 AM

Everything seems to run extremely well now. The only issue I am having is that the calculation in the code truncates everything to 2 decimals. Any ideas?

Thanks.

**shg** · 05-20-2010, 11:45 AM

The code doesn't truncate anything. Change the formatting to General.

**IALTO** · 05-20-2010, 12:28 PM

So the formatting of the cells in the workbook matter?

I am displaying cells in the workbook with only two decimals, but they have much higher precision. The format of the cells the macro is copying are currencies.

When the macro finishes, all the copied data is truncated to two decimals.