Excel® 2013 VBA and Macros

Index

32-bit and 64-bit compatible API declarations, 511-512

A1 references

case study, 102-103

versus R1C1 references, 99-100

above-average records, returning with formula-based conditions, 221

absolute references, using with R1C1 references, 104-105

Access

ADO

records, adding to database, 473-474

records, deleting, 478-479

records, retrieving, 475-476

records, summarizing, 479-480

records, updating, 476-478

tables, checking for existence of, 480-481

fields, adding to database, 482-483

shared Access database, creating, 471

accessing

Developer tab, 9

VBA help topics, 37-38

ActiveX controls

attaching macros to, 553-554

creating right-click menu, 299-300

Add method, 395-396

AddAboveAverage method, 392

adding

code to new workbooks, 302 ...

Get Excel® 2013 VBA and Macros now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.