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...
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
