Excel VBA Assistance - Website name does not show as sheet name

It is because the structure of the webpage has been changed, there is no "h1" element anymore on this webpage.
I don't know what exactly you are looking for (because you don't provide any samples), but probably this one :

In module : Get_Player_Stats
In subprocredure : Sub GetPlayerStats()

Change :

Please Login or Register  to view this content.

to :

Please Login or Register  to view this content.

Thank you for the reply. An example of what I would like for my file to do is when I click on the Get Stats button from Sheet 1, the first new sheet created (in this case the sheet name should be Wilson Ramos) comes up with the name of Sheet4 instead. The second sheet created would be named Ryan Zimmerman, but instead it is named Sheet 5, the next sheet should be named Danny Espinosa instead of Sheet6, and so on with the URL list. Thank you for looking at this and let me know if you need any other info.

You are welcome.

In that case, try to change :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hello,

I need a quick support from this group.
I am in need to create a simple Excel Tool that should have the following:
1) Questions with Answer Options
2) Set of Questions would be under some categories which will have some weightages
3) Each Answer Options will have some specific scores
4) After completion of filling the questionnaire, the result should reflect in an overall score (may be out of 100)

Can someone help me on this? I think a re-usable macro enabled sheet (in the similar line) should work with some editing/customization that I will do.

Thank you in advance!

Cheers.

This worked perfectly! Thank you so much for the help!!

You are welcome, glad I can help.


Regards