Index_R

---

R

R1C1 notation, 179

Raiseevent statement, 310

Range box in PivotTable wizard, 344

range names

reserved, 182

in SERIES formulas, 331

substituting for range references, 333

Range object, 161

methods available to, 164

received by Worksheet_Change, 275

returned by ActiveCell property, 109

returned by RangeSelection property, 116

specifying cells for recalculation, 120

range of cells, 521, 522

Range property, 166, 167, 542

range references, 331, 333

ranges. See also named ranges

arithmetic sum of, 206

comparing two or more, 124

defining on a chart, 325

defining using the Cells property, 172

drawing outlines around, 237

extending, 165

joining together, 173-74

largest value in, 206

manipulations of, 161

most common value in, 206

named, 177

naming guidelines, 178

not necessary to first select, 166

referring to, 166-69

returning multi-dimensional arrays, 185

selecting, 162-64

separating for tracking purposes, 173

separating with commas, 172

smallest value in, 206

standard deviation, 206

RangeSelection property, 116

Range(<cell>).Value property, 101

rate argument

of PMT function, 208

of PV function, 212

RATE function, 211

RDO (Remote Database Objects), 481

readability of code, 54

ReadOnly parameter, 130

read-only property, 304

Read-Only Recommended option, 130

ReadOnlyRecommended parameter, 136

reads and writes, reducing to a worksheet, 185

read-write mode, 131

recalculation, 275

Record Macro dialog box, 29

record pointer, 484

RecordCount property

of PivotCache object, 353

of PivotItem object, 356

of Recordset object, 492, 493

recorded macros, 325

RecordPosition macro, 361-64

RecordSet object

in ADO object model, 482, 491-94

in RunQuery routine, 513

Recordset property of PivotCache object, 353

recursive procedures, 97

red VBA color constant, 219

RedBorder procedure, 237

ReDim statement, 66

#REF! error value, 124

RefEdit control, 415

Reference argument, 389

reference materials, 7

references

to procedures, 96

referring to, 194

resolving, 311

References command, 452

References dialog box

displaying, 48, 96

referencing the ADO database library, 498

in Visual Basic Editor, 453

Refresh method

of ListObject object, 542

of Parameters collection, 489

of PivotCache object, 353

updating data, 352

RefreshDate property, 353

RefreshPeriod property, 353

RefreshTable method, 351

RegEdit program, 250, 256

regional settings, language specified in, 124

registry. See Windows registry

registry entries, 250

relational database, 467

relative references, 30

expanding names, 181

specifying for cells, 166

Relative References button, 30

Remove method, 315

RemoveItem method

of CommandBarComboBox object, 378

of ListBox control, 413

RemoveMap procedure, 556

Repeating property of XPath object, 558

reports, 342

REPT function, 199

Require Variable Declaration option, 50

Research task pane, 7, 20

research tools, updating, 8

reserved range names, 182

Reset item on the Run menu, 48

ResetAllPageBreaks method of Worksheets, 155

ResetColors method, 226

ResetFromRecorded macro, 363

ResetPivotTable macro, 361

Resize method, 186, 543

Restore button, 19

Result variable, 385

results, publishing on the Internet, 533-37

Resume command, 84

Resume Next statement, 84

RetrieveWebQueryData procedure, 529

Retry and Cancel buttons, 68

Return key, 127

Review text box, 439

Review_KeyPress event, 440

RGB color combinations, 221

RGB color values, 226-29

RGB function of Visual Basic, 220

RGB values

of colors, 221-23

setting gridline colors to, 230

of VBA color constants, 220

Right Arrow key, 127

Right function, 200

right-angled corners, 337

RightMargin property, 154

root directories of file structures, 289

Root element in a schema, 548

root object, 42

RootElementName property, 554

rounded corners, 327

RoundedCorners property, 337

row fields for a PivotTable, 358

row height, measured in points, 174

RowFields property, 351, 354

RowGrand property, 351

RowIndex property, 368

RowNumber text box, 422, 425

RowNumber_Change event, 425

rows

adding to tables, 478

allowing users to delete, 158

allowing users to format, 158

allowing users to insert into, 158

computing the previous, 425

copying to a worksheet, 514

in a database table, 468

maximum height of, 14

maximum number of, 14

referencing, 172

removing from tables, 479

retrieving all from a table, 472

retrieving from a database, 513

retrieving from one or more database tables, 471

retrieving selected, 473-75

sorting, 475

specifying for new items, 413

Rows property of Select, 172

RSQ function, 5

Run Macro dialog box, 48

Run menu, 48

Run method, 94, 95

Run Query button, 508, 517

Run Sub/UserForm item on the Run menu, 48

Run to Cursor item on the Debug menu, 47

RunCharMap procedure, 448

RunDatabaseQuery routine, 508

running total feature, 21

RunQuery routine

in Excel Query program, 509

in ThisWorkbook module, 512-14

Run-time error 1004, 360

RunWizard routine, 434

---