Ask Your Question

Help with Err 508 in Calc [closed]

asked 2018-01-10 10:33:05 +0100

JonNew gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-25 22:28:39.774451


Do you write comma as delimiter of parameters? Try semicolon

JohnSUN gravatar imageJohnSUN ( 2018-01-10 11:37:02 +0100 )edit

Thank You JohnSUN!! Works

Luis_s gravatar imageLuis_s ( 2019-12-04 09:27:53 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-01-11 21:15:41 +0100

JonNew gravatar image

Thank you, JohnSun, semicolons work. Also, found the answer thanks to question by and answer by Ratslinger:

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-01-10 10:33:05 +0100

Seen: 6,934 times

Last updated: Jan 11 '18