In this guide, I will start with VBA basics and give you practical examples of utilizing custom functions to unlock a whole new level of Excel mastery.

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

I've got an Excel 97 worksheet in which I need to validate some cells. No problem, I'll just use Data->Validate, right? Wrong. The built in validation works well enough as long as the user doesn't ...

How do you navigate between worksheets in Excel? In Microsoft Excel, there are several ways you can navigate between worksheets in Excel, such as using shortcut keys, hyperlinks, using the VBA editor.

I thought that I would do it in Excel using VBA and didn't come any further than creating some code for opening the "main" file to match against before rethinking it all.