I want to process each row of an Excel 2010 table of 200 rows using VBA. What is the most efficient way of coding this. A For....Next loop ? How can I use the table name to reference a cell ? If only 3 rows in the table have data (the remaining rows being blank), how can I detect this and stop the loop ?