Microsoft Excel 2019 VBA and Macros, First Edition

Index

Symbols

:= (colon-equal sign), 30

{ } (curly braces), in JavaScript, 536

-- (decrement operator), in JavaScript, 543

++ (increment operator), in JavaScript, 543

+ (plus sign), in JavaScript, 537

“” (quotation marks) in JavaScript, 537

; (semicolons), in JavaScript, 536

[ ] (square brackets), as Evaluate method, 103

3D Models, 551

24-hour clocks, formatting cells as, 115-116

32-bit API declarations, compatibility, 471-472

64-bit API declarations, compatibility, 471-472

9 runtime error (subscript out of range), 488-489

1004 runtime error

method range of object global failed, 489-490

troubleshooting, 199-200

VB Editor actions, 479-480

A

A1 references

copying formulas, 89-91

R1C1 references versus, 87-88

replacing multiple with single R1C1 ...