carolina has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Using SET
In which situation do you use SET when you using variables?
RE: Using SET
Hi Carolina
When you declare variables some variable types are Objects.
When assigning values to Object variables you need to Set the data. For example:
Non Object
Dim Counter As Integer
Counter = 1
Object
Dim MyRange As Range
Set MyRange = Range("A5:M500")
Hope this helps
Carlos