R
Radio button Value property, 242
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
ReDim statement, 14, 20 ‚ 22
Relative formulas, 241 ‚ 244
REP (replacement) function, user -defined, 231 ‚ 233
Replacing characters in a string, 231 ‚ 233
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
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