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 return an error
The macro will run fine so long as a user doesn't click the worksheet while it is running
The macro will run fine
2. What does the following piece of code do? Application.CutCopyMode = False
It is the equivalent of pressing Esc, which clears the data held in Excel's copy buffer
It deselects a range of cells surrounded by the “marching ants”
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 apostrophe character)
; (The semi-colon character)
" (The quote character)
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement