Info

SheetChange() event, 148, 158

SheetDeactivate() event, 148, 158

SheetExists() function, 78-79 SheetFollowHyperlink() event, 148, 158

SheetSelectionChange()

event, 148, 158 ShellExecute API function, 439, 461

shortcut keys, assigning, 16, 491

Show() function, 470

ShowCustForm() function, 213

ShowDetail feature (pivot tables), 274-276

signatures, digital, 15, 19

Sills, Richie, 292

sizing comments, 304-306 objects, 186-187 pivot tables, 241-243 ranges, 67

UserForms, 163, 441-442 SlowAverage() function, 383 SortConcat() function, 95-96 sorter function, 97-98

sorting data

BubbleSort function, 96 QuickSort function, 97 sort order

AutoSort, 246-247 controlling manually, 247

customizing, 318-319 SortConcat function, 95-96 sorter function, 97-98

sounds, playing, 462

SpecialCells function, 71-73

SpecialRange() function, 325

specific items, percentage of, 287

specifying ranges with Columns and Rows properties, 68 with top-left and bottom-right corners, 62

speedometer chart, 204 SpinButtons, 169-170

Sp]itWorkbook() function,

299-300 standard modules, creating collections in, 424-425

StartTimer() function, 460 statements

Do, 108-111 Exit For, 107 For, 103-105 loops directory files, looping through, 115-116 Do...Loop, 108-111 Do...Until, 111-112 Do...While, 111-112 For...Each, 113-114 For...Next, 103-108 While...Wend, 113 New, 363 Next, 103-105 NOT, 112 Option Base, 379 Property Get, 422-423 Property Let, 422-423 Select...Case, 101-102 Step, 106-107 To, 104

Type..End Type, 429 Until, 111-112 Wend, 113 While, 111-112 With...End With, 56 WithEvents, 416

state_period() function, 102 StaticRAND() function, 101 Step clause, 106-107 Step Into command (Debug menu), 42

stepping through code, 42-45

stock information, retrieving, 327-328 stock quote charts, 197

Stop Recording command

(Macro menu), 22 Stop Recording toolbar, 14, 22

stopping macro recorder, 22 StopTimer() function, 460 streaming data, 336-337 StringElement() function, 94-95

strings delimited strings, 94-95 finding within text, 98 names, 135-136 Sub Srch() function, 293-295

subscripts out of range,

475-476 substituting multiple characters, 92-93 subtotals adding, 254

automatic subtotals, 254 suppressing, 249

Subtotals() function, 249

SumColor() function, 83-84

summarizing records,

410-411 sums (pivot tables), 240-241, 284-285

supply curve chart, 205 suppressing totals, 249-250 surface charts, 197 SwapElements() function, 98

0 0

Post a comment