I'm struggling, I'm trying to do something pretty much the same as you. I've built the table in VBA. I can't select while in recorded macro mode. I've tried F5 but only the first row in the table is selected. I'm trying to left align the whole table. Any help would be appreciated. Cheers.