Excel VBA Select and Selection

Grab the Free VBA Quick Reference Guide
In this Excel VBA Tutorial we review Select and Selection.

Select is how you chose your range and Selection is the active selection in the workbook

Sub SelectRange()
Dim rng As Range

Range("A1:D50").Select

Set rng = Selection

Set rng = Range("A1:D50")

End Sub

Sub selectionRange()

Selection.Interior.Color = 255

Selection.ClearFormats

End Sub