Excel Macro's

  • Thread starter Thread starter mmassey
  • Start date Start date
M

mmassey

In layman's terms, what is a macro? can you make them for just about
anything? and how do you make one? (I get all the way to the part where you
click on record macro, then I am dumbfounded).
 
I am not that familiar with macros but I use them for like sorting
information or refreshing all pivot tables and stuff like that but once you
start recording a macro, it will record every single thing you do like if you
copy and paste something it will copy your moves. To stop recording you go to
tools, macro, and then stop recording. To use your macro you insert like a
button from forms, or you can just insert like rectangle or circle and right
click on it to assign the macro, and once you have done that it will act as a
button and the macro will do whatever you recorded it to do.
 
A macro is a piece of programming code that makes a computer do things. Most
often a macro helps the user with
- boring, time consuming, silly tasks
- tasks too big to do manually
- tasks too complex to do manually

I write my macros. It's just a language (Visual Basic 6). One needs to know
the language and the object one writes it for (here Excel).

Yes, you can do about anything with a macro.

Best wishes Harald
 
Back
Top