Excel VBA Macro Programming

R

Radio button Value property, 242

Radio buttons , 242, 244

Random number generator, 200 ‚ 201

Randomize statement, 200 ‚ 201

Range of cells

calculating, 217 ‚ 218

referencing, 136

transposing, 209 ‚ 211

Range method, on a variable, 207

Range object, 135, 155 ‚ 159, 276

in object hierarchy, 136

properties and methods , 155 ‚ 159

Value property, 136

Range of values, changing globally, 259 ‚ 262

Range.calculate method, 156, 217

RangeSelection property (Windows object), 151

ReadOnly property (Workbook object), 148

RecentFiles collection (Application object), 145

Recording macros, 138 ‚ 140

Recordset object, 181

ReDim statement, 14, 20 ‚ 22

RefEdit control, 105

Relative addressing, 241

Relative formulas, 241 ‚ 244

Rem statement, 296

REP (replacement) function, user -defined, 231 ‚ 233

Replace method, 158, 275

Replacing characters in a string, 231 ‚ 233

Reserved words, 23 ‚ 24

Reset method, 120

Resume Next statement (with On Error), 89 ‚ 90

Resume statement (with On Error), 89 ‚ 90

Return values for a message box, 66

Reversing a label, 219 ‚ 220

Right function (strings), 45

Rnd function, 200

Row and column headings, transposing, 209 ‚ 211

Row property (Range object), 157

Rows collection (Application object), 144

Rows and columns , coloring alternate, 245 ‚ 249

Rows.count property (Common Dialog), 247

RowWidth property (Range object), 158

Run to Cursor (in debugging), 80

Runtime errors, 78

Runtime mode (VBA), 78