Info

ReportByWeek() function,

267-268 ReportManyDetailsByCusto mer() function, 284-285

reports pivot table reports automatic subtotals, 254 blank report worksheets, moving data to, 251 executive overviews,

271-274 formatting, 253 outline view, 252-253 Product Line Manager sample report, 255-257 region/product reports,

276-279 Report workbooks, 250-251

Product Line Manager sample report, 255-257 Word, 373-376 Require Variable Declaration setting (VBE), 18

reserved names, 137-138 Reset button, 467

Reset command (Run menu), 43 ReSet() function, 309

resetFormatting() function, 513

resetValue() function, 515

Resize property (Range object), 67 Resize() event, 155

resizing comments, 304-306 ranges, 67

UserForms, 163, 441-442

resolution, 457-458

RetrieveNumbers() function, 93

RetrieveTop3Customer-

Detail() function, 275-276 ReturnMaxs() function,

99-100 RevenueByCustomers() function, 211

ReverseContents() function, 99

reversing cell contents, 99

RightAngleAxes property

(charts), 198 RotateFirstSlice() function, 200

Rotation property (charts), 198

round-tripping, 353-354 rows deleting with conditions,

325-326 entire columns/rows, referencing, 123 rows with largest values, identifying, 128-129

Rows property (Range object), 68 RowSource property (ListBox), 166

Run Macro button (Visual

Basic toolbar), 13 Run menu commands

Reset, 43 Run Sub, 44

Run Sub command (Run menu), 44 Run to Cursor command (Debug menu), 45

RunCustReport() function,

228-229 running. See also scheduling macros code to cursor, 45 macros, 16

ActiveX controls, 494 command buttons,

492-494 custom menus, 481-486 custom toolbars,

487-491 hyperlinks, 495-496 keyboard shortcuts, 491 timer, 460

running totals, 287-288 RunReportForEach-Customer() function, 231-233, 374-376

runtime, adding controls at,

440-443 Runtime Error 9, 475-476 Runtime Error 1004,

476-477 RunTimer() function, 460

0 0

Post a comment