Help with loop to fill color of shapes (US map)

My mistake, I read AH2:AH211 as if it was AH2:AH11.

You can add them all to sList. There does not need to be a comma after the last item in the list.

And obviously,

For i = 2 To 11

Becomes:

For i = 2 To 211

In the list, how would I include a media market name like "Charleston, WV"?

Change the comma (in sList) to ";" or some other character.

And then:

sArray = Split(sList, ";")

The point is that you have a list of items in one string separated by a character, then you use Split to split the string into a string array based on this character. It can be a comma, a semi-comma, "@", an empty space " ", or any character which you can put in a string.