Follow the steps below on how to use the VBA macro to switch between worksheets in Excel. Go on the Excel sheet whenever you run the program on the Microsoft Visual Basic for Applications window ...

Function AddOdd(Rng As Range) For Each cell In Rng 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 ...