You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macro... » 

You are an expert in Excel, but the macro recorder doesn't work and you can't make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros.

This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.Learn VBA syntax as easy-to-understand EnglishAutomate Excel's power tools: Pivot Tables, Charts, Advanced FiltersSave hours per week by automating redundant tasksCreate applications built on top of Excel with custom dialog boxesAutomatically produce hundreds of Excel reports in secondsUnderstand how changes in Excel 2007 impact your VBA macros «