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.

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 ...

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.