macros
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version Standard

replyReply Wed 20 Feb 2008, 16:42Delegate Esther said...

Esther has attended:
Excel Advanced course

Macros

Why?

For upcoming training course dates see: Pricing & availability

replyReply Mon 25 Feb 2008, 16:17Trainer Rajeev said...

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

 

Please browse our web site to find out more about
excel advanced training and other Microsoft training courses.

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.



View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard