I currently have code written to extract a whole HTML table from a website and paste it into my spreadsheet. I would like to be able to extract only a certain value from that table instead. For example, on the following webpage I would like to return the value contained in row 4, column 5 of the "1500 or more games played" table to Sheet1, cell A1 in my workbook. The macro will always reference the same "cell" in the webpage.


http://en.wikipedia.org/wiki/List_of...0_games_played


How do I achieve this in VBA?