Back to lesson
1. How many times can you refer to a variable in a piece of code?
As many times as you like
A few times
2. Once you assign an object to a variable, can you change its properties?
Yes, you can change the properties of the variable at any time
No, you cannot change the properties once the object has been assigned to the variable
Yes, you can change the properties, but only after you have run the macro at least once
3. Why is it problematic to refer to ActiveSheet in the sample code below?
ActiveSheet is not a valid piece of VBA code
You do not want the macro to run on the active sheet
If the active sheet changes, the macro may not run on the correct worksheet
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement