Having trouble inserting a formula into excel from access 2013 VBA.
this formula works if I put it directly in Excel
but when I try to put it there via VBA I've exhausted my tries!
.UsedRange 'Refresh UsedRange
Lastrow = .UsedRange.rows(.UsedRange.rows.Count).Row
this works (but with a ton of divide by zero errors!
.Range("BG3:BG" & Lastrow).Formula = "=AX3/AC3)"
This is what I want
.Range("BG3:BG" & LastRow).Formula = "=IF(OR(ISNUMBER(AC3)=FALSE;AC3=0);"N/A";AX3/AC3)"
I expect I'd need to get the quotation marks right!
I also tried things like
.Range("BG3:BG" & Lastrow).Formula = "=IF(OR(ISNUMBER(AC3)=FALSE,AC3=0);0;AX3/AC3)"
trying to eliminate the need for quotation modification just to see if that works! I could live with it if it did! But same error
application defined or object defined error 1004