Select All Cells In Worksheet with .Cells

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:

1

2

3

4

5

6

7

SubMySelectAll()

Sheet1.Activate

Sheet1.Cells.Select

EndSub

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

1

2

3

4

5

6

7

SubMySelectAll2()

Sheets("PlaceTabNameHere").Activate

Sheets("PlaceTabNameHere").Cells.Select

EndSub

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro – A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users!