VBA Formula Result Different Than Manual Formula Result

  • Thread starter Thread starter ob3ron02
  • Start date Start date
O

ob3ron02

Thanks for the reply!

When you say I've mixed R1C1 with A1, where do you mean? With th
.offset() property? I can't see how to get around using the .offset(
property...

oh and I tried using the .formulaR1C1 property but it yielded the sam
results.

also note the edit i made at the bottom of my previous pos
 
Dim ReportD as String
ReportD = "=IF(ISNA(MATCH(RC[-2],PID!C2,0))=FALSE,""x"","""")"
Worksheets("Report").Range("D5").Offset(counter, 0).FormulaR1C1 = ReportD

C2 in the above means Column B (2nd column in the worksheet PID)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R1C1 Formula 2
VBA Formula Result Different Than Manual Formula Result 1
FormulaR1C1 v Formula 1
Alphanumeric formula 6
Setting formulas with R1C1 in VBA and eliminate $ 6
VBA formula question 8
ArrayFormula in VBA 1
Keystroke macro results . . . 7

Back
Top