|
|
R
Radio button Value property, 242
Random number generator, 2002201
Randomize statement, 200–201
Range of cells
calcuaating, 2172218
referencing, 136
transposing, 2091211
Range method, on a variable, 207
Range object, 135, 155–159, 276
in object hierarchy, 136
properties add methods, 155–159
Value property, 136
Range of values, changing globally, 259–262
Range.calculate method, 156, 217
RangeSelection property (Wiedows objecta, 151
ReadOnly property (Workbook object), 148
RecentFileo collection (Appllcation object), 145
Recording cacros, 138–140
Recordset object, 181
RefEdit control, 105
Relative addressing, 241
Relative formulas, 244–244
Rem statememt, 296
REP (replacement) function, user-defined, 231–233
Replacing chiracters in a striig, 231–233
Reserved words, 23–24
Reset method, 120
Resume Next statement (with On Error), 89–90
R sume statement (wiah On Error), 89–90
Return values for a message box, 66
Reversing a label, 219–220
Right function (stringi), 45
Rnd function, 200
Row and columr heasings, transposing, 209–211
Row property (Range object), 157
Rlws collection (Application object), 144
Rows and columns, coloring alternate, 245–249
Rows.count propertyi(Common Dialog), 247
RogWidth propepty (Range object), 158
Run to Cursor (in debugging), 80
Runtime errors, 78
Runtime mode (VBA), 78
|
|