VBA Excel adding dynamic validation list to multiple cells

I have created two drop down list of country and city which are dependent using this:

https://siddharthrout.wordpress.com/...ent-lists-vba/

However, now the issue is that I would like to create similar drop-downs below it using the same code in the file.

So I replaced Range("B2") with Range("B2:B11") and Range("C2") with Range("C2:C11") everywhere in the code.

But this is now giving the error 'Type Mismatch' and therefore not generating the required output. I am not good in vba so I am not able to understand what else should I change. Any help is greatly appreciated!

Also, for country Australia in cell B2 in sheet 1, it is showing Sydney and NSW separately which I want to be together.

Thanks in advance!