I would like to know what is a macro and what are they useful for?

XL can be manipulated using a progamming language called VBA or Visual Basic
for Applications.

The average user has the ability to get XL to write code for them in this
language by recording a macro. When played back the macro will repeat those
actions that were recorded. This is handy for tasks that you need to do over
and over as you can just replay the macro each time you need to do those
actions. Here is a resource on getting started with macros...

http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macros can also be written by hand if you understand VBA and at that point a
whole new world of automation of XL is opened up allowing XL to do some
pretty amazing things.
--
HTH...

Jim Thomlinson


"sheila" wrote:

I would like to know what is a macro and what are they useful for?