Back to lesson
1. What is problematic about the following code? wsTarget = ActiveWorksheet
It should read: Set wsTarget = ActiveWorksheet
Nothing, this code is valid
It should read: wsTarget = Set ActiveWorksheet
2. How do you open the Find & Replace dialog in the Visual Basic Editor?
Press CTRL + H
Press CTRL + F
Press ALT + H
3. If your variables contain a mixture of cases, how does typing a line of code all in lower case act as a validation method?
If the code is valid, the casing will automatically correct when you press Enter
If the code is invalid, the casing will be highlighted in red when you press Enter
If the code is valid, the casing will be highlighted in yellow when you press Enter
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement