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"...