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