Forget the macro recorder - It’s not that easy

So why are not everyone writing macros?

If you’re reading this blog, you probably already know from experience: because writing macros is not easy.

Most tasks are repetitive BUT with slight differences that demand it to change/adapt according to case. So they need some sort of intelligence, which is not easy to program for anyone but software developers. Which is not the case for Excel business users.

What about the built-in macro recorder? Most people first encounter with macros involve the macro recorder and it creates the illusion that you don’t need to write a macro. Just perform the task you want to automate and record it. Then run it again and again.

Well, if your repetitive task is EXACTLY THE SAME every time, it may work. But almost always, there will be some differences:

• Different number of rows or columns
• Conditional tasks – merge A and B to get a product code only if B is numeric
• Changes in data for every iteration
• …

The macro recorder will record EXACTLY what you did when recording. So, if you delete the “-“ on the product code in cell C10 because it is a number, it will do it again to cell C10 next month – even if it is not a number and the number is on row 12 because the product list is different every month.

There is actually a very good use for the macro recorder – and it will be explained in a later post. But it is not writing macros.