Index_R

R

R1C1 notation, 192, 201

RaiseEvent command, 163

RaiseEvent keyword, 51

RAM, 572-73

random numbers , 234-35

Randomize function, 244

range, defined, 186

Range method, 187, 188, 202-3, 591

Range object, 186-87

and changing cells , 147

Consolidate method application to, 601

and CopyFrom-Recordset method, 662-63

in data searches, 589

hierarchy of, 796-97

in hierarchy of shape objects, 560

joining with Union method, 204

methods and properties, 845

and mouse events, 146

properties of, 58

use in editing preexisting invoice, 616

in user -defined functions, 310

Range("D4").Select command, 16

ranges of cells. See cells, ranges of

Rate_I_Hours function, 522-23

Rate_II_Hours function, 522-23

Rate_III_Hours function, 522-23

Read method, 276, 303

ReadAll method, 276, 303

ReadAttributes procedure, 427-28

ReadLine method, 276, 303

ReadTextFile method, 277

Ready property, 361

ready-made charts , 542-43

rec variable, 647, 648, 681-82

rec![article-nr] name , 657

recalculation of cells, 314

RecentFile object, 845

RecentFiles object, 845

rec!feld name, 657

rec.Fields("name").Value, 657

rec.Open sql, conn file, 654

Record-Count property, 720

RecordCount record, 660

RecordCount, Recordset property, 667

recording macros, 11-12, 16, 82-83

records. See data records

RecordsAutomatic Query command, 637

RecordsQuery Now command, 637

Records Sort command, 636

Recordset methods, 667

Recordset object, 647, 649, 654-62

adding data records, 661

data fields, 657-59

deleting records, 661

editing records, 660-61

methods and properties, 846

navigation in data records, 659

positional information, 660

possible errors, 661-62

Recordset types, 655-57

searching and locally sorting data records, 660

SQL abbreviations, 655

Recordset properties, 667

recur function, 107

ReDim command, 93

Redim field4(10), 96

Redim Preserve field4(20), 96

redo function, 80

RefEdit control, 53

distinguishing features, 432

properties of, 433-34

RefEdit object, 846

Reference object, 846

references, 69

References form, 133

Refresh Data command, 698

Refresh method, 293

Refresh options, 639, 709

RefreshData method, 728

RegEdit.exe program, 334

RegEdt32.exe program, 334

registry, Microsoft Office, 333-34

relational databases

Northwind database, 625-26

querying data, 625

relating data from different tables, 623-25

relations among several tables, 622-23

sharing data among several databases, 620-22

relational models, 571-72

relations, 573

defining between data field of two tables, 634

establishing among tables, 634

what they are, 571-72

relative recording, 16, 82

RelativeAbsolute Reference tool, 82

Remove All button, 688

Remove method, 714

Remove property, 166

RemoveAllBorders procedure, 211

RemoveSubtotal method, 690

repeat, 148-49

Replace Current Subtotals option, 688

Replace function, 237, 641-42

Replace method, 49, 200

ReplaceFormat := True parameter, 200, 201

ReplaceFormat property, 49, 200

report generators, 573

ReportCreate Test DataCreate Daily Report command, 544, 556

ReportCreate Test DataCreate Monthly

Report command, 544, 556

ReportCreate Test Data command, 545, 556

Require Variable Declaration option, 9, 73, 78, 87

Reset command, 278, 279, 305

Resize event, 158

Resize method, 191

"Result" custom style, 10

results worksheet, 672-73, 674

inserting data into, 684

result cells in, 677-78

Resume command, 382, 383

Resume Next instruction, 380-81, 383, 386

Returning External Data to Microsoft Excel dialog, 638

Right function, 236

RmDir command, 304

Rnd function, 36, 234-35, 244

rndInit variable, 548

rndmat field, 548

rng.CopyFromRecordset, Recordset method, 667

rng.Find "character string" method, 200

rollup, 702-3

RootFolder property, 302

rounding numbers, 233

RoutingSlip object, 846

Row property, 191, 299

RowDifferences method, 191

RowField range, 694

RowFields( ) method, 717, 728

RowGrand property, 716

RowHeight property, 195

RowRange property, 716, 728

Rows method, 191

Rows property, 36

Rows.Count, 299

RowSource property, 407