O

Object Browser, 51-52 object variables, 113-114, 182-183

objects, 19, 30. See also ranges

ADO (ActiveX Data Objects), 402-404 Axis, 189-191 ChartArea, 183-185 ChartTitle, 192-193 clsEmployee, 420 custom objects, 420-422 DAO (Data Access

Objects), 402 DataLabel, 191-192 DataLabels, 191-192 Err, 472

ErrorBar, 193-195 FormatConditions, 127 Object Browser, 51-52 object variables, 113-114,

182-183 PlotArea, 186-188 positioning, 186-187 properties, 32-33, 41-42 Series, 188-189 sizing, 186-187 Trendlines, 193-195 Word objects bookmarks, 371-373 creating, 363-364 Document objects,

365-366 object model, 364-365 Range objects, 368-370 referencing, 363-364 Selection objects, 367 Offset property (Range object), 65-66

offsetting ranges, 65-66

OKButton_Click() function, 212, 221-222

Oliver, Nathan P., 293, 327 On Error GoTo syntax, 470-471

On Error Resume Next syntax, 472-473 one-dimensional arrays, 380 OnTime() function, 337 open files, checking for, 456-457

open workbooks, checking for, 77-78 Open() event, 143 Open() function, 366, 392 opening text files delimited files, 392-394 files with less than 65,536 rows, 387 files with less than

98,304 rows, 394-397 files with more than

98,304 rows, 397-398 fixed-width files,

388-391 one row at a time, 395-397 Word documents, 366

OpenLargeCSVFast()

function, 297-298 OpenSchema() function, 411

OpenText() function, 36,

387, 394 operators, 217-218 Option Base statement, 379 option buttons, 167-168 optional parameters, 37

Options command (Tools menu), 118 OR operator, 217-218

order lead time, measuring,

269-271 out-of-range subscripts, 475-476

outline view, 252-253 overlapping ranges, creating ranges from, 69

overwriting names, 133

0 0

Post a comment