PDA

View Full Version : Solved: AutoFill VBA is not working with my formula :S



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.

Ugur
12-07-2009, 03:13 PM
Sorry, formula is fine I guess, copied it to new sheet and check the VBA, it works there. The problem was in labels data.

lucas
12-07-2009, 04:03 PM
Just mark it solved. You expained your error and solution.

use the thread tools at the top of the page.

That way no one will waste time looking at a thread that's already been resoved.