内容简介
GetbeyondthebasicswithExcel2007macrosNowyoucantakeyourExcelskillstothenextlevelwithhelpfromthishands-onguide.Excel2007MacrosMadeEasyshowsyouhowtocreate,run,andrevisemacrostosimplifyrepetitivetasksandstoretheinstructionsforcomplicatedones.You'lllearntouseVisualBasicforApplications(VBA),addmacrostotheExceltoolbar,andshareyourmacroswithotherusers.Discoverhoweasyitistodevelopcustommacros,savetime,andboostproductivity.RecordandeditmacrosCreateanddebugmacrosinVBASavemacrostothePersonalMacroWorkbookorotherworkbooksCreateVBAsubroutinesandfunctionsDevelopinteractivemacrosFormatcellsusingmacrosCreatevariablesandarraysApplylogictomacroswithIf/Then/ElseroutinesUseloopstoprocessdataAddcontrolstoyourworksheets
作者简介
GailPerryisaCPA,financialjournalist,theauthormorethan20booksonfinancialsoftware,taxes,andpersonalfinance.SheisthemanagingeditorforAccountingWEB,acontributingeditorforSMBFinancemagazine,andaninstructor.