i always thought macros were when you can automate functions in excel. but i understand that there is another functions of macros. what are these and can someone give me an example? i work well with examples. it doesnt have to be graphical. just something i can relate it to in excel thanks!