On the Developer tab, click the Visual Basic button in the Code group. A Microsoft Visual Basic for Application window will open. Click the Insert tab and select Module in the menu. A new model is ...

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel. Once you stick your toe into the VBA waters, you’ll realize how powerful and ...

Sometimes hiding certain columns in an Excel spreadsheet can be helpful: Doing so can make spreadsheets easier to read or you may have other reasons to hide them. In any case, hiding columns in ...