Excel 2007/2010 – Select All Cells (VBA)

To select all the cells on a sheet using VBA you can use the .cells property of the worksheet, without specifying a specific cell.

An example of selecting all cells on Sheet1 using the code name Sheet1:

Sub MySelectAll()
     Sheet1.Activate
     Sheet1.Cells.Select
End Sub

An example of selecting all cells on Sheet1 using it’s tabname. You can replace “PlaceTabNameHere” with the name of your tab:

Sub MySelectAll2()
     Sheets("PlaceTabNameHere").Activate
     Sheets("PlaceTabNameHere").Cells.Select
End Sub