Question: vba when to use set?
Answer: The Set keyword is used to create new objects, creating a new Range, for example. The Set keyword comes in handy when you want to simplify long lines of code. It is also speeds up your code when VBA executes it. The first line introduces you to a new variable type - As Range.