ExcelMacroVBA.pptVIP

Excel Macro and VBA Recording/Editing Macro Recording macro: Tools/Macro/Record new macro Editing macro: Tools/Macro/Macros Excel’s macros are VBA procedures Learning VBA with Macro Spreadsheet operations: Copy/Paste/Fill/Clear/Delete Format cells Adding a worksheet Insert/Delete rows, cols Window scroll Command Bar commands Data/Sort/Subtotal Commands Range(A3:F25).Sort Key1:=Range(C4), Order1:=xlAscending, Key2:=Range(B4), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase :=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal Selection.Subt