ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macros? (https://www.excelbanter.com/excel-discussion-misc-queries/57334-macros.html)

Weave

Macros?
 
What are macros? Why do you use them? When do you use them? How?

Jerry W. Lewis

Macros?
 
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...m#vbatutorials

Jerry

Weave wrote:

What are macros? Why do you use them? When do you use them? How?




All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com