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)
--
Regards,
Tom Ogilvy



"ob3ron02" wrote in message
...

Thanks for the reply!

When you say I've mixed R1C1 with A1, where do you mean? With the
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 same
results.

also note the edit i made at the bottom of my previous post


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile:
http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=270473