Originally Posted by gmaxey

You are getting a runtime error because your are trying to set a string variable to a variant variable.


Change ctrlTitle() as String to just ctrlTitle
or
Change Array("Name", "Position" , "Etc") to Split("Name,Position,Etc", ",")


Now sure you don't want a msgbox popping up every time your code finds a CC with content.