Excel VBA Tutorial - Intro To Ranges
Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
Understanding the range in VBA is really powerful. In this video we do an intro you to what the Range is and some of the Basic Uses and the Syntax.
We additionally go review some comon pitfalls when the sheet (or parent) is not defined
CODE
==========================
Sub Rangeless()
Dim rng As Range
Set rng = Range("a1:C10")
rng.Select
Range("A1").Select
Range("a1:C10").Select
Range("C8").Font.Bold = True
Range("B1:F10").Cells(2, 2).Select
Range("C2") = "This is a Sentence"
End Sub
