You need to specify more detail.
Macros are progams you create and then run when you need them. In run them
by choosing Tools, Macro, Macros... but you first need to create them. You
might take a look at John Walkenbachs book - Power Programming in Excecl.