VBA: Select All Cells

September 19th, 2004 | Categories: VBA | Tags: , ,

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

Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
No comments yet.