562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
In this module you'll learn how to select cells and ranges in Excel, and how to move around a worksheet.
Choose what you want to learn from the list of lessons above.
This page provides a brief summary of what you've learned in this module. You can click here to download the example code shown below.
You can select a single cell by passing its reference into the Range property and applying the Select method.
You can refer to the selected cell using the ActiveCell property.
'Change the value of the selected cell
ActiveCell.Value = "Wise Owl"
You can refer to a single cell using the Cells property.
You can refer to a block of cells using the Range property.
You can refer to a block of selected cells with the Selection property.
Selection.Interior.Color = rgbBlue
You can move to another worksheet by passing its name to the Worksheets property and applying the Select method.
You can refer to the currently selected sheet with the ActiveSheet property.
Range("A1").Value = ActiveSheet.Name
You can refer to a worksheet based on its position from left to right.
You can move to another workbook by passing its name to the Workbooks property and applying the Activate method.
You can refer to the workbook in which your code is stored with the ThisWorkbook property.
You can modify properties of a range without needing to select it first.
Range("B3").Value = "Wise Owl"
You can modify cells on another worksheet without needing to select the worksheet.
Worksheets("Sheet2").Range("A1").Value = "Wise Owl"
You can modify cells in another workbook without needing to activate the workbook.
Workbooks("Book2.xlsx").Worksheets("Sheet1").Range("A1").Value = "Wise Owl"
You can use the End property to find the edge of a block of populated cells.
To find the bottom of a list which has empty cells, it's perhaps better to go up from the bottom of a worksheet.
You can use the End property to select from the top to the bottom of a list.
You can use the End property to select from the top left to the bottom right of a list.
You can use the CurrentRegion property to refer to an entire table.
You can use the Offset property to move up, down, left and right on a worksheet.
You can combine the End and Offset properties to reach the next blank row in a list.
This page contains reference material for the code used in this module.
The End property of a Range object allows you to use one of four constants to specify the direction:
There is currently no test for this module.
25 Aytoun Street