Dear Excel experts,
I am currently strugling with this problem: I just need to insert a simple formula into an excel cell, but it does not seem to want to work.
The code:
The second line gets highlighted and I get Run-time error '1004' (Application-defined or object-defined error)
Range("O6").offset(0, counter2).Select ActiveCell.FormulaR1C1 = "=IF(AND(R[-1]C<>0;RC[-1]>=R1C213);RC[-11];0)"
To me the formula seems correct so what could possibly be the problem?
Last edited by wolis; 05-09-2012 at 07:55 AM.
replace the semi colons with commas:
ActiveCell.FormulaR1C1 = "=IF(AND(R[-1]C<>0,RC[-1]>=R1C213),RC[-11],0)"
Thanks mohd9876
Is this always used in VBA, or does it depend on my settings?
formular1c1 always uses US settings. formular1c1Local uses your settings.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks