Keep your data table as simple as possible and save it to your website.

In the user workbook, on its own worksheet, create a web query by
using
Data External New web query

In step 2. choose the entire page.

Once the query has been created, right-click on any cell in the query
area and click data range properties for further options.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=546169