macro

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

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

Macro

resolvedResolved · Low Priority · Version 2003

Karen has attended:
Excel Introduction course
Excel Intermediate course
Word Advanced course
Excel Advanced course

Macro

what is a macro

RE: macro

Hello Karen
Thank you for your question

When you have something you need to do over and over again you can write or record a macro to do it for you so you dont have to manually go through the steps each time. You can then attach the macro to a button in excel which can be clicked to perform the task or you could have it so that it automatically runs upon saving. You can use the macro recorder to build them which is best for beginners or directly write them in code if you are more advanced.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range.

View all Excel hints and tips


Server loaded in 0.07 secs.