Macro

Hi Sarah


Thank you for your question regarding Macros

The purpose of macros is to automate repetitive tasks, due to the nature of how they are created (recording of mouse clicks/keystrokes) these exact steps will be carried out when the macro is implemented.

If any amendments to the macro are needed you would either need to create a new macro for that or if you feel confident enough to delve into the VBA (Visual Basic) coding to edit the macro, this could be another option. Understanding the visual basic element to macros would give you far more flexibility on the implementation of macros in changeable tasks.

I have included a link below for the course outline of the Excel VBA course we deliver, this would give you the understanding required to manipulate your macros in a far more efficient manner

https://www.stl-training.co.uk/excel-vba-2007.php


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.


Kind Regards,


Nafeesa

Microsoft Office Specialist Trainer