VBA Project 2



In this series of Excel files you see how to fill a variable sized grid with the counting numbers. Double left clicking on any cell in the grid, bar the first, will highlight it and all its multiples in the grid. A Checkbox allows all multiples to be kept on the grid rather than refreshing itself, therby providing a demonstration of the Sieve of Eratosthenes to be demonstrated. Primes are automatically couloured in a darker shade. Just primes can be shown using another Checkbox embedded in the worksheet if required.
It is always handy to have a routine to produce any sized grid and so here one is! Once again, I'll be happy to help in any way with your understanding as no Word notes are supplied again.

If you can modify this file to fill the grid with any linear sequence (as in the previous VBA Project 1) then you are clearly understanding matters!

Excel Files (1), (2), (3), (4)

My advice is for you to download the files directly to your hard drive by right-clicking on the link and then selecting "Save Target As..." - otherwise the Excel files may not work fully in your browser window!