Back to lesson
1. What will happen if you shorten the recorded code below: Range (“E6:E10”).Select Selection.Copy To read as follows: Range(“E6:E10”).Copy
The macro will run fine so long as a user doesn't click the worksheet while it is running
The macro will run fine
The macro will return an error
2. What does the following piece of code do? Application.CutCopyMode = False
It deselects a range of cells surrounded by the “marching ants”
It is the equivalent of pressing Esc, which clears the data held in Excel's copy buffer
It copies the data from the selected cells so it can be pasted elsewhere
3. What character can you type at the beginning of a line of code to prevent it from being executed?
" (The quote character)
; (The semi-colon character)
' (The apostrophe character)
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement