VBA – Select All Cells

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:

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

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!

alt text

Learn More!

<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues:


  1. bob October 17, 2017 at 2:20 pm - Reply

    What about imitating the behavior of “select all” or Ctrl-A? This selects literally all cells including empty cells.

    • Steven Rynearson October 17, 2017 at 3:43 pm - Reply

      CTRL + A doesn’t always select all cells in a worksheet. It depends on what data is contained in your worksheet and where your cursor is. If you use CTRL + A while in a block of data, it will only select that data block. If you press CTRL + A again then it will select all cells.

      IF you did want to mimic this behavior in VBA you could use Sendkeys to mimic those keystrokes. There might be other ways, but I’m not aware of them off the top of my head.

Leave A Comment