Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion Standard

Esther has attended:
Excel Advanced course

Macros

Why?

RE: Macros - Reason!!

Dear Esther

Thank you for attending Excel Advanced course. I hope that it was beneficial to you.

I am not sure what your question implies but I assume you meant that why do we need to record macros.

The main reason for creating Macros is when you find yourself performing repetitive tasks and want to automate them. Typical examples could be that every time you open a new workbook you have to always change the page setup to landscape and change the margins to specific measurements.

It is advisable to record group of actions as macros that are related. You can even create a Macro using VBA which can have customised function.

Please bear in mind that whatever action you are about to record as macro you should be confident in carrying out those actions. If you make mistakes then those mistakes will get recorded as well.

I hope this has helped you in answering your question.

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.