Hi all,
I’m trying to search webpages for words like “(Denmark)”, “(Sweden)” etc.
Currently I have listed all the countries (Words) I’m searching for in Range("c1:HR1").
Then all the words, which exists on the website, gets returned to me.

The problem is now, I want to know in which order they appear on the website, or at least want to know, which country is first to be listed on the website.

Example:
Website:
Sweden is number one in this category, Denmark is second, Finland is last.

My VBA now, gives med the countries in alphabetic orders (Because of the order of my range): Denmark, Finland, Sweden.

I want my VBA to give med Sweden, Denmark, Finland

Hope you can help me 😊