What are Macros ?

  • Thread starter Thread starter jineshjasani
  • Start date Start date
J

jineshjasani

Hi everyone,

I wanted to know about Macros. What are these macros ? How they ar
used ? Are they simple formulas which can be used when repetition i
required or they have some other purpose also
 
To the question: A macro is a piece of programming code used to automate
tasks. It can do almost everything on a / to a computer very very fast.

Professional macros are typically used for
- Boring repeating tasks. Do this and that to this and that, format it, copy
it, print it, mail it, save a backup, clean it up.
- Huge tasks. Loop thousands of units, sort, find, extract, replace, test
for this and that.
- Complex tasks. Ask the user for some variable, then connect to a remote
database and get all corresponding data for her.

and yes, you can also use the macro editor to write custom formulas (called
Functions) for use in spreadsheets.
 
Back
Top