I try to fill a column with individual IF-statements in a VB macro in a
for-loop.
Something like:

Cells(row, 1).FormulaR1C1 = "=IF(bool,1,2)"
row = row + 1

It is much slower than inserting a constant statement.
I think the reason is, that Excel is going to calculate the result of
the IF-statement at the same time the macro inserts the formulas.
Is there a way to prevent Excel from automatically updating the cells
during the macro?

Thank you for your help so far.

Parity


--
Parity
------------------------------------------------------------------------
Parity's Profile: http://www.excelforum.com/member.php...o&userid=25023
View this thread: http://www.excelforum.com/showthread...hreadid=478724