Is there a way in VBA to force End(xlToLeft) to stop at the last data cell within a Table for a particular row when starting from a cell outside of the Table? At present End(xlToLeft) is stopping at the last column within the Table, even if it is empty. I am using Office 2007. Thanks.