Search:

I am giving up for the night -- I have tried everything I can think of for now. I did import the table from the destination page with the excel browser (I could only import the whole page, wasn't...

stepping through the code when it gets to the line:

Sheets(sht).Select

i get the error message

run time error '1004'

application-defined or object defined-error

well that line is in the code that you provided, so I guess I did

in your instructions you wrote:

Then select all the teams in the table and define a name to the range, a brief survey of the...

I clicked debug and step into in the VB code window and it highlighted the very first line:

Sub NFLfromStatfox()

but I kinda don't think that is what you were looking for, I don't know how to...

I get:

Run-time error '9':
Subscript out of range



Thanks for the help -- and again thanks for the heads up that excel can scrape web pages!:lock2:

I tried running the visual basic/excel macro code above but it didn't work for me, it created all the sheets with the teams and the years but they are all empty. Maybe this weekend I will try again...