Solved: AutoFill VBA is not working with my formula :S
> 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.
Sorry, formula is fine I guess, copied it to new sheet and check the VBA, it works there. The problem was in labels data.
Last edited by Ugur; 12-07-2009 at 04:09 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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Posting Permissions
Reply With Quote
