So, I've got a simple concatenation that is referencing a cell with 'Cells'. However, it returns "#NAME?"

Here is the source:


Sub Objective2()

Dim X As Integer
X = 1
Do Until IsEmpty(Cells(X, 2)) = True
    Cells(X, 12).Value = "=Sheet1!$A$1 & Sheet1!$B$1 & Sheet1!$C$1 & cells(X, 2) & Sheet1!$D$1 & Sheet1!$E$1 & Sheet1!$F$1"
    Cells(X, 12) = Cells(X, 12).Value
    X = X + 1
    Selection.Offset(1, 0).Select
Loop

Range("L2").Select

End Sub
The code works it's just declaring the new value of the selected cell that doesn't. What am I doing wrong?

X increments fine until, it calls the other sheet fine. I think it's the cells() function in the concatenation that's broken but I know no other way.

Thanks!

James