Category: Wiley Excel Power Programming with VBA

List of Tables Chapter 3: Formula Tricks and Techniques Table 3-1: COMPARING SIMPLE FORMULAS IN TWO NOTATIONS Table 3-2: EXCEL ERROR VALUES Table 3-3: COUNTING FORMULA EXAMPLES Table 3-4: SUMMING FORMULA EXAMPLES Table 3-5: INTERMEDIATE FORMULAS WRITTEN IN ROW 2 IN FIGURE 3-9 Chapter 4: Understanding Excel’s Files Table 4-1: EXCEL COMMAND LINE SWITCHES Table […]

List of Listings Chapter 10: Creating Function Procedures Listing 10-1: MySum Function

List of Sidebars Chapter 2: Excel in a Nutshell How Big Is a Worksheet? What’s New in Excel 2007? What’s New in the Visual Basic Editor? Chapter 3: Formula Tricks and Techniques Referencing Data in a Table Hidden Names The Secret to Understanding Cell and Range Names Chapter 4: Understanding Excel’s Files Workspace Files Before […]

CD Content Following are select files from this book’s Companion CD-ROM. These files are for your personal use, are governed by the Books24x7 Membership Agreement, and are copyright protected by the publisher, author, and/or other third parties. Unauthorized use, reproduction, or distribution is strictly prohibited. For more information about this content see ‘What’s on the […]

Excel 2007 Power Programming with VBA byJohn Walkenbach John Wiley & Sons 2007 (1099 pages) ISBN:9780470044018 Packed with procedures, tips, tricks, techniques, and ideas, this guide provides comprehensive, coverage of the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features. Table of Contents Excel 2007 Power Programming with […]

V

Index V Val function, 987 validation data entry, 648-651 user entry, 322 UserForms, 436 #VALUE! error, 60 value, selecting cells by, 340-342 Values property, 595 VALUES_FROM_SERIES function, 596 Variable uses an Automation type not supported in Visual Basic error, 992 variable-length strings, 205 variables data types and, 193 data types, determining, 198, 201 declaring, 197-199, […]

W

Index W Web browsers, Help system, 792-794 Web pages, developers and, 14 Weekday function, 987 WeekdayName function, 987 welcome messages, 639 what-if models, 106 While…Wend statement, 981 Width # statement, 981 WindowActivate event, 638, 656 WindowDeactivate event, 638, 656 WindowResize event, 638, 656 windows activating, 977 docking, 157 hiding, 16 Windows API default printer information, […]

X

Index X XLAM add-in files AddIns collection, 710 chart sheets, 711 introduction, 537 visibility, 710-711 worksheets, 711 XLSM files and, 710 XLB files, 90 XLM macro sheets formulas, 18 introduction, 16 XLM macros, 358-361 XLSM add-in files chart sheets, 711 visibility, 710-711 worksheets, 711 XLAM files and, 710 XML (eXtensible Markup Language) description, 42 exporting […]

Y

Index Y year extended property, 839 Year function, 987 year of date, 987

Z

Index Z ZipFiles procedure, 855-856 zipping files, 855-858 zoom, 30 Zoom event, 661

List of Figures Chapter 1: Excel 2007-Where It Came From Figure 1-1: VisiCalc, running in a DOS window on a PC running Windows XP. Figure 1-2: The original Excel 2.1 for Windows. This product has come a long way. Figure 1-3: Excel 3 was a vast improvement over the original release. Figure 1-4: Excel 4 […]

P

Index P /p directory switch, 74 page breaks, 934 Page Layout tab (Ribbon) description, 728 RibbonX code, 742-743 PageCount function, 348 pages extended property, 839 Partition function, 985 passing arguments to procedures, 251-255 literals to procedures, 253 passwords add-ins, 124 assigning, 124 security of, 124 VBA code, 36-37 workbooks, 36 path, current, 982 Path not […]

Q

Index Q QAT (Quick Access Toolbar) customizing, 736 data forms and, 410-411 description, 24 file, 89-90 QBColor function, 985 Quattro Pro, 7 QueryClose event, 439, 456, 661 Quick Access Toolbar. See QAT (Quick Access Toolbar) quick sort, arrays, 352 quick-and-dirty spreadsheets, 103

R

Index R /r filename switch, 74 RaiseEvent statement, 980 random access, text files, 841 random number generator, initializing, 980 RandomColor function, 928 RandomIntegers function, 374-375 Randomize statement, 980 randomizing, ranges, 375-377 Range object Cells property, 182-183 Range property, 181 range objects, 16 Range property, 179-182 RangeNameExists function, 357-358 RangeRandomize function, 375-377 ranges bold formula entries, […]

S

Index S /s switch, 75 SaveAllGraphics procedure, 586-587 SaveAllWorkbooks function, 344 SaveChartAsGIF procedure, 585 SaveDefaults procedure, 812 SaveSetting statement, 980 saving charts as GIF files, 525 files, date, 363-364 workbooks, 344 SayIt function, 363 scope cells, 56 functions, 283 procedures, 239-240 ranges, 56 Scroll event, 661 ScrollBar control, UserForms, 418 ScrollBarZoom_Change procedure, 460 scrolling charts, […]

Categories