Search:

UVA: Do you have any idea what "Runtime error 9: subscript out of range" might refer to? Is there anything else that I need to do in terms of defining the data in order to get this to work?
Thanks...

If you copy the button that is posted in this thread and then paste it in microsoft excel, the real code will show up. The button in the thread doesn't work for me either, but that's how I got...

When I go line by line through the code, the error comes up when it gets to the url query piece. The error box says "Runtime error 9: subscript out of range." Any ideas what this might refer to?
...

UVA,
I am trying to follow your instructions on page 3 of this thread to import NFL data from statfox. I created a list of the 32 teams, highlighted the list, and defined it as "NFLteams." I then...