Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Select Range Of Cells. Lets say our example cell E6 is on a sheet called Sheet2. You can also copy values by assigning the value of one range to another.
The same idea applies to the left right or up arrows. Step 1 Select one cell on the current worksheet. Dim sht as WorkSheet Set sht This WorkbookSheets Data Range Cells 11Cells 1ColumnsCountEnd xlToLeftSelect.
Once you start executing the codes practically most of the time you need to work with a range of cells so it is important to understand how to work with a range of cells and one such concept is VBA Selection of Range.
Shift Arrow Key If you use Shift along with your arrow keys you can select multiple cells one at a time. You can also select a range which is the number of rows and columns aways from a range. To select an entire range you need to define the address of the range and then use the select property. You can use either of the following options to select it.