Microsoft Developer
Looping over collections exercise
Average difficulty
This Microsoft Developer LOOPING OVER COLLECTIONS exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL VISUAL BASIC course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Listing jewels
| 1) | Download the files needed to start this exercise: exercise-242.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | This worksheet contains lots of hidden jewels - try using the Edit / Find menu to find one. |
| 3) | Write a macro which loops over the collection of all the cells in your worksheet (Cells), and lists out the values and addresses of all the non-empty cells found to the immediate window - the final result should begin like this: |
Some jewels may be a bit iffy!
|
|
| 4) | While your macro runs, why not get a cup of coffee? You probably have about three minutes to think how you might have written this macro to run more quickly! |
Thank you for showing an interest in this Excel Visual Basic training course!
