VBA formula not working, trying to insert an image

[Joe84]

Hello

So I recently added some QR codes to an excel sheet I was using to generate labels.
And now I wanted to generate these labels automatically, however im stuck on this section of code.

I have been trying for a few days to make it work.
My Excel is in spanish, but I have translated the formula to english.

The code in B2 is working fine if it is introduced manually, but VBA doesn't seem to recognise it.

Worksheets(SheetName).Cells(2, 2).Formula = "=IMAGE('https://api.qrserver.com/v1/create-qr-code/?size=150x150&data='&TEXTJOIN(,,A2,A1))"

Any help would be much appreciated.

Regards

 

[smozgur]

I tried both options and yes they work, and yes the codes are ok.

Thank you very much

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.