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 homester@gmail.com and answer by Ratslinger:
Setting a formula in macro basic