Help with Err 508 in Calc

I am using a Calc macro to insert a vlookup formula into a cell but obtain an Err 508. The macro works with a simple formula like = J6 or =(J6) or = SUM(J3+J6) but not with the lookup formula. I have got round this by placing the vlookup formula for example in J6 and then pasting =J6 into J3. However, I would appreciate help with what I am doing wrong. Thank you.

Do you write comma as delimiter of parameters? Try semicolon

Thank You JohnSUN!! Works

Thank you, JohnSun, semicolons work.
Also, found the answer thanks to question by and answer by Ratslinger:
Setting a formula in macro basic