Search:

Both rows and columns are represented in the .Cells function by number. So, "A1" = row 1, column 1. "Z43" = row 43, column 26.

That's because you're telling it to start on row 31 by using "lastrowsheetone". Just use the "x-1" part...

Any examples on importing and manipulating xml using vba?

Any sample code for logging into a user account for Pinnacle to get to the Dynamic Odds pages (the ones with drop-downs) rather than the static lines available to everyone?