Thread: Multiple line
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
linglc linglc is offline
external usenet poster
 
Posts: 31
Default Multiple line

I have a vlookup in my code. Because the code is long I break it into two
lines but I am getting a message that says there is a syntax error. The code
is as follows. Anyone can help me? Thanks.

Selection.FormulaR1C1 =
"=IF((ISERROR(VLOOKUP(C[-4],Table!C[-6]:C[-5],2,0))), _
"""",VLOOKUP(C[-4],Table!C[-6]:C[-5],2,0))"