Hi All,
I have little peace of code that I need help with it. I'm trying input formula with VB, formula should be place into cells, dynamic range. Here is my code:
PHP Code: 
Set DataRange = Range("J10", Range("P65536").End(xlUp))
    DataRange.Formula = _
    "=IF(ISNA(VLOOKUP(J10,Currency!$C$12:$D$184,2,FALSE)),"1",VLOOKUP(J10, Currency!$C$12:$D$184,2,FALSE))" 
I must be doing something wrong with syntax or something and I can't see what I'm doing wrong. I got "Compile error: Expected: expression". Any thoughts on this would be greatly appreciated
Thanks a lot
Izet