If you're going to use that you can shorten it a bit:but you'll probably get away with justSet originalTable = Selection.CurrentRegion If originalTable.Row < 4 Then Cells(4, 1).CurrentRegion.Selectthen if you want a visual chaeck of what originalTable is just typeSet originalTable = Cells(4, 1).CurrentRegion
originalTable.select in the Immediate pane of the VBE (Ctrl+G of you can't see it).