Microsoft Excel Training Videos

Macro: Working with the active cell in Microsoft Excel


The ActiveCell property in Microsoft Excel returns a Range object that represents the cell that is active. You can apply any of the properties or methods of a Range object to the active cell, as in the following macro. The training video demonstrates the concept clearly.
Sub SetActive()
Worksheets("Sheet1").Activate
Worksheets("Sheet1").Range("A2").Activate
ActiveCell.Font.Bold = True
ActiveCell.Font.Size = 12
ActiveCell.Value = 123
End Sub


Custom Search

Microsoft Excel Training Videos