Using a String in a formula via vba

[jensslofstra]

Hey everbody
I have been trying to get this formula to work via vba:
=CONCAT("Week ";A1)

But if I try this with the Cells.FormulaLocal or Cells.Formula like this it doesn't work:
Dim Week As String
Week = "Week "

Cells(1,1).FormulaLocal = "=CONCAT(" + Week + ";A2)"
If i run this and check it in excel the formula in the cell is:
=CONCAT(Week;A1)
So without the quotation marks.

Does anyone have a solution for this?
Thanks a lot

[Keebellah]

Try this

Please Login or Register  to view this content.

if not change the ; to a ,

[Phuocam]

Try:

Cells(1,1).FormulaLocal = "=CONCAT("" Week "";A2)"