reformat data if column criteria is meet

I placed a button in the spreadsheet:

 Private Sub CommandButton1_Click()
' reformat the input
If [Test]=”array”, Then
   [Lab #] , [Name], [Result], [Final]
   Else
   Exit Sub
End If
End Sub

and a workbook open event in the spreadsheet.

When the code is run I get: syntax error

the

 If [Test]=”array”, Then

is highlighted. Thank you .