Info

AppEvent_Workbook-

Activate(), 159 AppEvent_Workbook-

AddinInstall(), 159 AppEvent_WorkbookAddin

Uninstall(), 159 AppEvent_Workbook-BeforeClose(), 159

AppEvent_Workbook-

BeforePrint(), 160 AppEvent_Workbook-

NewSheet(), 160 AppEvent_Workbook-

Open(), 160 trapping, 416-418 ApplySpecialFormattingAll() function, 127

area charts, 196 Areas collection, 74 array formulas, 129 arrays advantages of, 383-384 array formulas, 129 declaring, 379-380 defined, 379 dynamic arrays, 385 emptying, 382-383 filling, 380-382 multidimensional arrays,

380 names, 136

one-dimensional arrays, 380 passing, 386 transposing, 384

Assign Macro dialog box, 18

assigning keyboard shortcuts, 491 macros to form controls, 17-18 to toolbar buttons, 16-17

AssignMacro() function, 324

audio, 462

Auto List members option

(charts), 182-183 AutoFilterCustom() function, 234

AutoFilters, 233-234, 292-293

automatic subtotals, 254 automation. See also charts; pivot tables; Web queries

Advanced Filter, 207-208 case study, 230-233 criteria ranges, 215-218 Filter In Place option,

225-226 formula-based conditions, 219-224 no matching records, handling, 224 unique list of values, extracting, 208-215 xlFilterCopy, 226-229 AutoFilters, 233-234,

292-293 case, changing, 322-323 cells highlighting, 308-309 non-contiguous cells, selecting/deselecting, 311-313 progress indicator,

319-320 selecting with SpecialCells, 324-325 conditional formatting AutoFilter with more than two conditions, 292-293 cell highlighting, 308 conditional formatting with more than three conditions, 291-292 custom data transposition,

310-311 custom delete event, 323-324

custom sort order, 318-319 cut/copy/paste, disabling,

316-318, 328-329 files closing and deleting,

295-297 CSV files, importing,

297-298 CSV files, reading and parsing, 298-299 exporting to Word,

302-303 listing, 293-295 formula bar, 326 page setup, 313-315 protected password box,

320-322 rows, deleting with conditions, 325-326 time to execute code, calculating, 315-316 Word, bookmarks, 371-373 compile errors, 361 Document objects, 365-366

early binding, 359-361 filtered reports, 373-376 late binding, 362 object model, 364-365 object creation, 363-364 object references, 363-364

Range objects, 368-370 Selection objects, 367 workbooks combining, 300-301 deleting after specific date, 295 separating worksheets into, 299-300

worksheets filtering and copying data to, 301-302 separating into workbooks, 299-300

AutoSort() function, 247

averages, 284-285

Axis object, 189-191

AxisDemo() function, 190

0 0

Post a comment