Excel 2007 Formulas or Excel VBA Macro Programming

Excel 2007 Formulas

Author: John Walkenbach

• This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere

• Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else

• John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel

• Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features

• Includes a valuable CD-ROM with templates and worksheets from the book

New interesting book: 350 THAI AND NOPINESE LOW FAT RECIPES FOR HEALTHY L or El Vino

Excel VBA Macro Programming

Author: Richard Shepherd

Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You’ll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.

Richard Shepherd (Reading, Berkshire, England) is a qualified accountant with a special interest in computer languages, particularly Visual Basic, and he’s spent the last 20 years developing computer software in blue chip organizations.

Table of Contents:

Ch. 1	The basics	3
Ch. 2	Variables, arrays, constants, and data types	11
Ch. 3	Modules, functions, and subroutines	25
Ch. 4	Programming basics : decisions and looping	33
Ch. 5	Strings and functions and message boxes	43
Ch. 6	Operators	67
Ch. 7	Debugging	77
Ch. 8	Errors and the error function	87
Ch. 9	Dialogs	91
Ch. 10	Common dialog control	107
Ch. 11	Command bars and buttons	117
Ch. 12	The Excel object model	125
Ch. 13	The Excel object model - main objects	141
Ch. 14	Using Excel to interact with other office programs	161
Ch. 15	Charts and graphs	171
Ch. 16	Working with databases	177
Ch. 17	API calls	183
Ch. 18	Class modules	193
Ch. 19	Animation	199
Ch. 20	Converting labels to numbers and numbers to labels	205
Ch. 21	Transposing a range of cells	209
Ch. 22	Adding formula details into comments	213
Ch. 23	Calculating a range	217
Ch. 24	Reversing a label	219
Ch. 25	Who created the workbook?	221
Ch. 26	Evaluating a cell	225
Ch. 27	Sorting worksheets into alphabetical order	229
Ch. 28	Replacing characters in a string	231
Ch. 29	Timed events	235
Ch. 30	Auto totaling a matrix of numbers	237
Ch. 31	Absolute and relative formulas	241
Ch. 32	Coloring alternate rows and columns of the spreadsheet	245
Ch. 33	Coloring cells containing formulas	251
Ch. 34	Summing cells by reference to a master cell	255
Ch. 35	Globally changing a range of values	259
Ch. 36	Displaying hidden sheets without a password	263
Ch. 37	Searching multiple sheets and workbooks	269
Ch. 38	Brighten up your comments	277
Ch. 39	An alternative to message boxes	287
Ch. 40	Working with shapes	291
Ch. 41	Turning your VBA code into an add-in	295
App. A	ASCII character codes	303