Ugur
12-07-2009, 03:11 PM
> http://www.vbaexpress.com/kb/getarticle.php?kb_id=325
I've tested this VBA Code with simple formulas and it was working great.
But now, with different formula, it doesn't do anything:
My formula on the cell is:
=IF(AND(OR(E3=1222, E3=1232, E3=1242, E3=1252), OR(D3=1, D3=2, D3=3), OR(C3=10, C3=11, C3=12), G3>5, F3>0.01, (F3/G3)>0.001),(G2-G3)/F3, 0)
macros doesn't run and fill this formula to the rest cells.
I've tested this VBA Code with simple formulas and it was working great.
But now, with different formula, it doesn't do anything:
My formula on the cell is:
=IF(AND(OR(E3=1222, E3=1232, E3=1242, E3=1252), OR(D3=1, D3=2, D3=3), OR(C3=10, C3=11, C3=12), G3>5, F3>0.01, (F3/G3)>0.001),(G2-G3)/F3, 0)
macros doesn't run and fill this formula to the rest cells.