VBA performance with building formulas

[jkj115]

I am having a performance issue with this code.

Please Login or Register  to view this content.

The above code takes forever to put the formula into each cell. However, if I change the code for rcell to "rcell.value=1", it flies through it. Is there a way to make the formula more efficient?

Thanks!

[RHCPgergo]

Not sure, but what if you change rCell.Formula to rCell.Value?

[jkj115]

thanks for suggestion..did not make it any faster

[RHCPgergo]

Can you post the full macro? Maybe it would give additional insight.

[jkj115]

That really is the full macro. See below

Please Login or Register  to view this content.

I did some tests to confirm that the slow part is putting the formula into "rCell"