Creating an array with special characters

[SeniorTom]

I'm trying to create an array with some unique name that I will use for a match function. VBA does not like my approach.

Here are the names: D'AURELIO, DUNN DB, DUNN DJ, SMITH BA, SMITH (TO), SMITH K

Here is what I tried but it was rejected:

Dim specialName (D &"'"& AURELIO,DUNN&" "&DB,DUNN" "& DJ,SMITH" "& BA,SMITH &"("& TO&")",SMITH&" "& K) as string

Regards,
Tom

 

[Tetra201]

Try

Dim specialName
specialName = Array("D'AURELIO", "DUNN DB", "DUNN DJ", "SMITH BA", "SMITH (TO)", "SMITH K")

 

[SeniorTom]

Thanks, That works.
Tom