Hi All,
I am trying to derive a formula for excel.
Below works.
Dim Test As String
'Test = "Car; color=blue;"
But now I want to add more fields and I do not want them to be fixed. e.g. (Test = "Car; color=blue;Model =Toyota;Year=2002;")
so I change to
Dim Test As String
Dim X As String
Dim Y As String
X = Toyota
Y = 2002
Test = "Car; color=blue;Model ="X";Year="Y";"
But I faced synatx error. What could be the issue?
Any help is appreciated!
Regards,
Nironto
Bookmarks