What is an Excel macro?

Forum home » Topics » What is an Excel macro?

What is an Excel macro?

An Excel macro is a set of recorded instructions using a mouse and keyboard which when 'run' will carry out the instructions.

Each recorded macro creates code in the background which can be modified through the Visual Basic Editor.

Macros are usually created when you have repetitive tasks that you would like to have automated. Using macros will save time when completing certain tasks each day in your Excel spreadsheets.

An example of this could be downloading data from another source then having to remove some columns, formatting other columns and so on. Doing all these tasks on a daily basis can take some time, however, creating a macro that does all the tasks at once will save a lot of time.

Related forum posts:

What is a Macro?

I have heard the mention of Macros and it is a term I have heard used, but what exactly is a Macro?

Read forum post

 

Simple Excel macros

how do you start a macro and when are they used? can you give an example of a simple macro?

Read forum post

 

How do I fix my Excel macro?

What would be the typical procedure to follow if a Macro I ran wasn't working, and noone in the office was able to fix it?

Read forum post

 

Testing Excel macros

How do i test a Macros across different workbooks?

Read forum post

 

Macros

Can you do Macro's across different software programs such as Sage?

Read forum post

 

Hiding excel tabs using macro

How do you hide tabs on excel and show only the file chosen on the user form?

Read forum post

 

Macros

How do you copy Macros from other people's worksheets?

Read forum post

 

Macros

Can a recorded macro be edited?

Read forum post

 

macros

what is the difference between a macro and a formula

Read forum post

 

Macros

How do they work?

Read forum post

 

Related articles

Break The Mystery Of Code With Excel Macros

Even if you have no knowledge of VBS (Visual Basic for Applications) program code, it's simple to create a macro in Excel 2010. Here, we take a look at how easy it is to combine even the most complicated cell formatting information into any of your worksheets.

Read article

 

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.1 secs.