excel-vba Ranges and Cells Saving a reference to a cell in a variable
Example
To save a reference to a cell in a variable, you must use the Set syntax, for example:
Dim R as Range
Set R = ActiveSheet.Cells(3, 1)
later...
R.Font.Color = RGB(255, 0, 0)
Why is the Set keyword required? Set tells Visual Basic that the value on the right hand side of the = is meant to be an object.
