75.

R

R1C1 reference style

vs. A1, 110

converting formulas from A1 style, 116

in formulas, 113

overview, 110

relative references in, 111

turning on, 110

random numbers

creating custom function, 164-70

generating, 150-51

Visual Basic vs. Excel functions, 164

Range class

Borders property, 102

Interior property, 105

Offset property, 102

Resize property, 102

selecting in Object Browser, 98

Range object

Activate method, 97-98

active cells and, 96

Address property, 116

BordersAround method, 105

Cells property and, 92

Formula property, 116

FormulaR1C1 property, 116

overview, 89

in PivotTables, 135-37

range-returning properties, 98

Value property, 112-13

Range property

Array function and, 75

Cells collection, 93

as member of Range class, 98

overview, 90

ShapeRange object and, 75

viewing in Object Viewer, 90-91

ranges, worksheet

adding borders, 102-5

adding formulas, 111-13

adding values, 111-13

comparing via CompareCells macro, 150-52

creating formulas from addresses, 114-16

defining database records as, 41

formatting, 102-7

formatting portions, 105-7

in PivotTables, 135-37

referencing, 90-102

relative vs. absolute references, 115

Selection property vs. ActiveCell property, 98

recording macros

to create charts, 78-79

FormatCurrency macro, 5-6

MergeVertically macro, 10-13

overview, 5-6

Record Macro button, 70

records, PivotTable, 126

rectangles, adding to worksheets, 70-73

references, cell

A1-style vs. R1C1 style, 110-11

building formulas using addresses, 114-16

relative vs. absolute, 115

regions. See CurrentRegion property

relative references

designating, 115

overview, 108

in R1C1 reference style, 111

RemoveGrid macro, 13-14

renaming

macros, 15

shapes, 77

worksheets, 63

repetitive tasks

using conditionals, 141-48

using loops, 148-60

reports. See MakeReport macro

Resize property, 102

RGB property

vs. Color property, 106

Fill object, 106

vs. SchemeColor property, 75

Right function, 279

row fields, 134

RowFields collection, 130

rows, worksheet, 94-95. See also records, PivotTable

Rows collection, 95

Rows property, 94-95

running macros, 29

run-time errors

ignoring, 171-74

overview, 170-71

role of Err object, 175-78

role of On Error Resume Next statement, 178

trapping, 178-81

Run To Cursor command, 158



Microsoft Excel 2002 Visual Basic for Applications Step by Step
FrameMaker 6: Beyond the Basics
ISBN: 735613591
EAN: 2147483647
Year: 2005
Pages: 122
Authors: Lisa Jahred

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net