Back to lesson
1. How many times can you refer to a variable in a piece of code?
A few times
As many times as you like
2. Once you assign an object to a variable, can you change its properties?
No, you cannot change the properties once the object has been assigned to the variable
Yes, you can change the properties of the variable at any time
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?
If the active sheet changes, the macro may not run on the correct worksheet
ActiveSheet is not a valid piece of VBA code
You do not want the macro to run on the active sheet
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement