Excel: Create Tables in VBA

I have an Excel Workbook downloaded from an Internet site. It has only one sheet with 50 suppliers listed on it. Each supplier is shown with a header row and the next row shows the shipping parameters in 10 columns. I need a VBA code for Excel 10 to loop through the sheet and create tables and rename the table for each shipper. I can record a macro that works fine, but the shippers change over time then the macro will not work. When recording the macro I click on the first column in the row showing the parameters (Shipper ID) and Excel knows the range for the table. I am new to VBA and trying to learn, any help is appreciated.

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of October 29, 2013.

For more resources for Microsoft Excel