Macros?

J

Jerry W. Lewis

Macros are programs that are written in a subset of Visual Basic (VBA)
that is supplied with Excel. It is used to automate repetative tasks,
add new functionality, etc.

To get started, you might try recording a macro (Tools|Macro|Record New
Macro) and then doing a task in Excel that you often repeat. When you
are finished, press the stop button to stop recording the macro. Then
you can run the macro by Tools|Macro|Macros|Run to repeat the exact steps.

A good next step might be to try some of the tutorials listed at
http://www.mvps.org/dmcritchie/excel/excel.htm#vbatutorials

Jerry
 
Top