Using different QuerySelectors in loop

I have an issue where different websites require different types of QuerySelector (i.e. getelementsbyclassname, getelementsbytagname, querySelectorAll, etc.) in the loop to be able to return a result.

As it stands, this code WORKS to retrieve the website information if I use a hard-coded FIX SELECTOR at the line of "Set list = html.querySelectorAll(ID)" but it DOESN'T WORK if I try to make it VARIABLE based on the sheet row attributed query.name in the loop.

I'm not sure if this is simply assigning the correct variable-type but I just don't know how to handle making this part work...

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)