01 - Range Object Quiz

To get the Developer Tab, do the following:

To change cell B4 to the number 45, enter Range("B4") = 45

In order to put Text Strings into a range, you need to surround your text with:

If you want to save your workbook as Macro Enabled workbook, you need to save it with the following extension:

What are the short-cut keys to launch the VB Editor?

To test the Macro/Module before actually running, you can launch the debugging process by placing the cursor inside the code in the VB Editor and press F8 which will perform the actions one by one as outlined in the presented code. This is called 'Stepping Through' the code.

Which short-cut keys is used view a list of available macros to run?