Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Use Evaluate function to execuate function

Public Sub ConcatenateExample1()    Dim X As String, Y As String    X = "Jack "    Y = "Smith"    MsgBox Evaluate("CONCATENATE(""" & X & """,""" & Y & """)") End Sub