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

macro

ResolvedVersion 2003

Violette has attended:
Excel Advanced course

Macro

Could you take me steps by steps how to create a macro and how to run it ?

RE: Macro

Hi Violette

Thanks for the question

The following are the main steps in creating a macro

1. Start the Macro Recorder (Tools-Macro_Record New
Macro)
2. Give the Macro a name and click OK. The macro recorder will be running and you will have the stop recording tool bar available
3. Carry out the actions that the macro is to do
4. When finished, click Stop Recording

To run the macro
1.Go ToTools-Macro_Macros
2. Select the Macro to Run
3. Click Run

Hope this is useful

Regards

Stephen

Tue 29 Dec 2009: Automatically marked as resolved.

Excel tip:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

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.1 secs.