Thread: Macro - Insert formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_385_] mudraker[_385_] is offline
external usenet poster
  
Posts: 1
Default Macro - Insert formula

It is not the # that is causing the problem but the fact that you have a
text string containg ". To overcome this you need to use multiple "

try

ActiveCell.FormulaR1C1 = "IF(VLOOKUP(RC[2],Sup_list,1,FALSE)=""" &
"#N/A" & """, """ & "No" & """,""" & "Yes" & """)"


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=540629

Reply With QuoteReply With Quote