CurrentRegion is the block of filled cells around a cell, bounded by empty rows and columns, exactly what Ctrl + A selects on the first press.

Code

Range("A1").CurrentRegion.Copy

• Copy a table

  Range("A1").CurrentRegion.Copy → Copies the whole table starting at A1

  Without knowing its size.

• A table variable

  Set tbl = Range("A1").CurrentRegion lastRow = tbl.Rows.Count → The table as a variable

  Then work with it.

• Sort a table

  Range("A1").CurrentRegion.Sort Key1:=Range("B1"), Header:=xlYes → Sort the block

  Whole-table operations.

• Stops at blank rows and columns, so a blank row splits the region.
• Faster to write than End(xlUp) when the data is contiguous.
• ListObject ranges are better for real Tables.

• A stray value next to the table extends the region.
• A blank row inside the data cuts it short.