R
R1C1 reference style vs. A1, 110 converting formulas from A1 style, 116 in formulas, 113 overview, 110 relative references in, 111 turning on, 110
random numbers creating custom function, 164-70 generating, 150-51 Visual Basic vs. Excel functions, 164
Range class Borders property, 102 Interior property, 105 Offset property, 102 Resize property, 102 selecting in Object Browser, 98
Range object Activate method, 97-98 active cells and, 96 Address property, 116 BordersAround method, 105 Cells property and, 92 Formula property, 116 FormulaR1C1 property, 116 overview, 89 in PivotTables, 135-37 range-returning properties, 98 Value property, 112-13
Range property Array function and, 75 Cells collection, 93 as member of Range class, 98 overview, 90 ShapeRange object and, 75 viewing in Object Viewer, 90-91
ranges, worksheet adding borders, 102-5 adding formulas, 111-13 adding values, 111-13 comparing via CompareCells macro, 150-52 creating formulas from addresses, 114-16 defining database records as, 41 formatting, 102-7 formatting portions, 105-7 in PivotTables, 135-37 referencing, 90-102 relative vs. absolute references, 115 Selection property vs. ActiveCell property, 98
recording macros to create charts, 78-79 FormatCurrency macro, 5-6 MergeVertically macro, 10-13 overview, 5-6
Record Macro button, 70
records, PivotTable, 126
rectangles, adding to worksheets, 70-73
references, cell A1-style vs. R1C1 style, 110-11 building formulas using addresses, 114-16 relative vs. absolute, 115
regions. See CurrentRegion property
relative references designating, 115 overview, 108 in R1C1 reference style, 111
RemoveGrid macro, 13-14
renaming macros, 15 shapes, 77 worksheets, 63
repetitive tasks using conditionals, 141-48 using loops, 148-60
reports. See MakeReport macro
Resize property, 102
RGB property vs. Color property, 106 Fill object, 106 vs. SchemeColor property, 75
Right function, 279
row fields, 134
RowFields collection, 130
rows, worksheet, 94-95. See also records, PivotTable
Rows collection, 95
Rows property, 94-95
running macros, 29
run-time errors ignoring, 171-74 overview, 170-71 role of Err object, 175-78 role of On Error Resume Next statement, 178 trapping, 178-81
Run To Cursor command, 158 |