View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ob3ron02[_2_] ob3ron02[_2_] is offline
external usenet poster
 
Posts: 1
Default VBA Formula Result Different Than Manual Formula Result


I don't really understand your post, Don. Is what you're saying that
should write my code as follows (without the = sign inside the quote
for my string assignment)?
Code
-------------------
Dim ReportD As String
ReportD = "=IF(ISNA(MATCH(R[0]C[-2],PID!B:B,0))=FALSE, ""x"","""")"
Worksheets("Report").Range("D5").Offset(counter, 0).Formula = Report
-------------------
This just seems to put the string in the cells as text and no
formulas.

Thanks,

To

--
ob3ron0
-----------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...fo&userid=1545
View this thread: http://www.excelforum.com/showthread.php?threadid=27047