Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...

If you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...

How to add line numbers to VBA

The other day I had a client ask me to create a reminder in an Excel document that would pop up several times a day. It had to run at...

Recording macros in Excel is an easy way to automate repetitive tasks. Maybe you receive a new file every month with your sales figures...

If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...