UEU-co logo

R


Previous Page

Next Page

Index

R

/r filename switch, 74 RaiseEvent statement, 980 random access, text files, 841 random number generator, initializing, 980 RandomColor function, 928 RandomIntegers function, 374-375 Randomize statement, 980 randomizing, ranges, 375-377 Range object Cells property, 182-183 Range property, 181 range objects, 16 Range property, 179-182 RangeNameExists function, 357-358 RangeRandomize function, 375-377 ranges bold formula entries, 647 changes, monitoring for, 647-651 in charts, 595-598 contained in another, determining, 334-335 copying, 316-317 copying, noncontiguous, 342-344 copying variably sized, 318-319 counting visible cells, 366 drag and drop over chart, 603 dragging over chart, 603 exporting to HTML file, 849-852 exporting to XML file, 852-855 moving, 318 naming, 53-54, 952 randomizing, 375-377 reading, 336-337 scope, 56 selected, looping through, 329-332 types, 327-329 UserForms, selecting in, 452-453 validate data entry, 648-651 variant arrays, transferring to, 339 writing to, 336-339 RangeToVariant function, 340 Rate function, 985 R1C1 notation, 50 read position, text files, 985 reading ranges, 336-337 text files, 843, 844 from text files, 979 read-only workbooks, 124 RecolorChartAndPlotArea procedure, 927 recording macros, 930, 937 recursion, 833 RecursiveDir procedure, 834-835 ReDim statement, 980 #REF! error, 60 RefEdit control Frame control, 453 MultiPage control, 453 text strings, 453 UserForms, 418, 452-453 references CommandBar objects, 764 UserForm controls, 444-445 References collection, VBProjects collection, 863 Registry Add-in Manager and, 93 application entries, 980 Converters section, 93 deleting settings, 978 Error Checking section, 93 File MRU section, 93 Options section, 93 Recent Templates section, 93 Registry Editor, 91 Resiliency section, 93 Security section, 93 settings, 92-94 settings, listing, 983 Spell Checker section, 93 StatusBar section, 93 UserInfo section, 93 values, listing, 983 relative cell references introduction, 49 macro recorder, 159-162 .rels file, RibbonX code, 740 Rem keyword, comments and, 192 Rem statement, 980 Remote server machine doesn’t exist or is unavailable error, 992 RemoveControl event, 661 RemoveDuplicates procedure, 465 RemoveVowels function, 299-300 renaming directories, 830 files, 830 repeating characters or strings, 986 Replace function, 985 Replacements too long error, 992 ReplaceModule procedure, 868-869 replacing, modules, 868-869 Require Variable Declaration option (VBE), 153 reserved words, 194 Reset method, 768 Reset statement, 980 ResetAll method, 769 resetting shortcut menus, 768-769 Resize event, 603, 654, 661 Resume statement, 980 Resume without error error, 990 Return without GoSub error, 989 reverse pivot table, creating, 568-570 ReversePivot procedure, 570 Review tab (Ribbon), 728 RGB color system, 902-903 RGB function, 902, 985 RGB (red/green/blue) color code, 985 RGB2DECIMAL function, 904 Ribbon access, keyboard, 24-25 Add-Ins tab, 728 buttons, simple, 22 buttons, split, 23 buttons, toggle, 22 check boxes, 23 commands, appearance, 730 commands, executing, 408-410 controls, accessing, 732 controls, demo, 745-752 custom interface, 550-554 customizing, 114 Data tab, 728 Developer tab, 728 drop-downs, simple, 22 dynamicMenu control, 752-754 Formulas tab, 728 hiding/showing, 931 Home tab, 728 Insert tab, 728 Page Layout tab, 728 Review tab, 728 spinners, 23 Sub procedures, 243 tabs, activating, 735-736 View tab, 728 RibbonX code callback procedures, 739-740 controls, creating, 746-752 errors, displaying, 737 GetEnabled callback procedure, 743-744 GetPressed callback procedure, 743-744 groups, creating, 746 imageMso images, 741 Initialize callback procedure, 743-744 introduction, 736 Page Layout tab, 742-743 .rels file, 740 tabs, creating, 745-746 TogglePageBreakDisplay callback procedure, 743-744 workbook, creating, 737-739 Right function, 985 RmDir command, 830 RmDir statement, 980 Rnd function, 985 Round function, 985 rounded numbers, 985 row absolute cell references, 49 rows deleting empty, 332 duplicating, 333-334 empty, deleting, 332 hiding, 123 increasing number, 933 naming, 55 selecting, ListBoxes and, 474-476 RowsetComplete event, 638 RSet statement, 980 RTrim function, 985 Run method, 244 Run Sub/UserForm command, procedures, 241 running macros, 930 runtime errors, error-handling and, 255 runtime version of Excel, 127 RunTimeButton procedure, 873

Previous Page

Next Page

Leave a Reply


Time limit is exhausted. Please reload the CAPTCHA.

Categories

apply_now Pepperstone Group Limited