Courtesy of PC Magazine
Many of us have automated tasks in Microsoft Excel by recording simple macros. But recorded macros can only do so much; for instance, they can't check the contents of a cell before performing an operation, and they can't pop up dialog boxes so that you can make choices. To do this, you will need to learn Excel's scripting language, Visual Basic for Applications. Read today's tip to learn more.
For the solution, click below:
For more Solutions, click below: