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

Macro

ResolvedVersion 2003

Fri 12 Dec 2008, 16:51 Delegate Koo said...

Koo has attended:
Excel Advanced course

Macro

How do you copy Macro to create similar Macros but with a different values?

Tue 16 Dec 2008, 10:51 Trainer Amanda said...

RE: Macro

Hello Koo

Thank you for your question and welcome to the forum.

It seems that if you want to copy a macro, you need to do this within the Visual Basic Editor (VBE).

I've included a link below which contains several useful questions with step-by-step instructions, including how to copy a macro:
http://office.microsoft.com/en-us/excel/HP052047111033.aspx

I hope this helps.

Kind regards
Amanda

Mon 22 Dec 2008: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Macro

Macro

RE: Macro

Excel articles

Excel tip:

Quickly insert a function