OK, that makes a little more sense! Thanks!
Is there a shorthand method for referencing an area (more than one row and column) within a range object that denotes a large table? For example, if MyTable is a range object (variable), how would I denote the range of Cells(2,1) to Cells(5,5) within MyTable? I guess the long way would be:
MyTable.Range(MyTable.Cells(2,1),MyTable.Cells(5,5))
Is there a shorthand substitute?