Increase your salary if you know how to write them
A macro is series of statements that tells Excel to perform a specific function.
An example would be to hide row 3 on the current spreadsheet.?
?Rows(3).Visible = False
is macro code also known as VBA (Visual Basic for Applications) that will perform this function.
A macro can be invoked via
Tools ? Macro ? Macros.. (2003)
View??? Macros (2007)
or press Alt+F8,
select the Macro to run and pressing the Run button.??
Excel comes with a Macro Recorder.??This tool is used to record your actions while using Excel.??You can then Run the macro which will replay the steps you?ve taken.??The beauty of macros in Excel is that if you don?t know how to code something but can do it via Excel, then you can have Excel show you how.??It?s not perfect, but it?s a great place to start.