May 2017 -

What are Macros?

Macros are just simply Procedures which can be viewed and edited inside the Visual Basic Editor (VBE). If you double click on a Module, you will notice that your recorded Macros is shown as Code inside the Module. It will have the following structure. Sub MacroName Code ……. End Sub

Read More

Insert the Date In Excel

A simple way to insert the date in Excel is first to select a cell in your active worksheet. Then hold down the CTRL key and press the ; (Semi-colon) key. This will input the current date into that cell.

Read More