Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

How to Select All Cells using Excel VBA?

One of the easiest way to select all cells from the current worksheet using Excel VBA is using the cells property of the Worksheet and the calling the Select function without specifying the index or name of the cell.

How to Select All Cells using Excel VBA?

For example, below is a code snippet that selects all the cells from the worksheet “TestWorkSheet”.

Sub DP_SelectAllCells()

     TestWorkSheet.Activate

     TestWorkSheet.Cells.Select

End Sub