Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type =AddOdd (B4:B14) and hit Enter to calculate the total odd numbers in a given ...

This is why you should put any code which acts on Cells directly in the Worksheet objects module.<BR><BR>If you would like to see a sample VBA Excel project, send me a PM, and I'll send you one.