troubleshooting Question

Trouble inserting formula =IF(OR(ISNUMBER(AC3)=FALSE,AC3=0);0;AX3/AC3) into excel column via VBA

Avatar of Peter Groves
Peter Groves asked on
VBAMicrosoft ExcelMicrosoft Office
5 Comments2 Solutions89 ViewsLast Modified:
Having trouble inserting a formula into excel from access 2013 VBA.
this formula works if I put it directly in Excel

IF(OR(ISNUMBER(AC3)=FALSE;AC3=0);'N/A';AX3/AC3)

but when I try to put it there via VBA I've exhausted my tries!

With wks

  .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

Thankls

Pete
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros