Excel VBA Select and Selection
Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
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
