#name error on correct formula

Hi everyone,

I need some help with a question I bet most of you can answer. I've searched online for an answer but still haven't found it.

So here is my question.
I have VBA paste a formula into a cell, and it gives a #name error in Excel.
If I just copy/paste the formula or just open it and press enter, it works, so the formula is correct.

the formula is: =TEKST.SAMENVOEGEN(A11;B11;C11) (to put strings from different cells together)
This is used in a row called lRow.
the code I wrote is:

Please Login or Register  to view this content.

Maybe the error lies in using the lRow-variable?

Thanks in advance and greetings

If my translation is correct, it looks ok aperture from the variable separator is a comma in the VBA and semi-colon in the function.

You could, of course, just use: =A11 & B11 & C11 and get the same result. Easier to put into the VBA, too.

Regards, TMS

---------- Post added at 10:27 AM ---------- Previous post was at 10:24 AM ----------

Please Login or Register  to view this content.

Just tested both formulae:

Please Login or Register  to view this content.

You will get a #NAME? error if the lRow variable is not defined or have a value set. If it's not defined, you'll get a compile error if you use Option Explicit.

Regards, TMS

---------- Post added at 11:16 AM ---------- Previous post was at 11:14 AM ----------

You're welcome. Thanks for the rep.

I reckon you probably needed

Please Login or Register  to view this content.

and you'd need to use semicolons instead of commas if that's how you usually enter them