Excel VBA macros: How to record a VBA macro

It is a good idea to automatise time consuming routine tasks in Excel. You don't need to know how to implement VBA macros, because you can just record your tasks. In following example I record a macro that assumes that I have people's whole names listed in column A and want to split names (first name and last name) into columns A anB. This is good example when simple recorded macro can save you from doing this routine task all over again.

Here is a video that demonstrates the VBA macro recording and shows how to run the macro (Tip: If you have difficulties to see the video, try to maximise it from lower right corner):