Yes, if the state or city shows "(number)" is the number of cities or locations in that city.

Let me explain, there is already a macro (macro 2) that needs, as manual user input, the classes of each level, then the macro gets the addresses/street only with those inputs. Now, I'm using this logic because I'm trying to do something a kind of "generic" macro (macro 1) that could work for other few sites that have similar structure (with same levels) only introducing some pure text content (state, city, location, address) present in website (nothing of html). This macro I'm trying to do, will extract the classes that would be the input for "macro 2". Macro 1 would feed with the classes Macro2, and Macro 2 would get the text info needed.

One of the goals is only give text input to "macro 2" that any without knowledge of html, could look the desired website and write in 4 cells of worksheet, the text for state, city, location, address.

I know each site needs a custom code when we are trying to do some web scraping, but in this case, my idea is to do this logic to take advantage of visual similarities between some websites. I hope make sense.

Regards