Index_S

S

Save As dialog, 110

Save method (Workbook object), 130, 148

SaveAs method (Workbook object), 130 ‚ 131, 148

SaveAs method (Worksheet object), 154

Saved property (Workbook object), 128, 148

Schedule parameter (OnTime method), 236

Scope and lifetime of variables , 13

ScrollBar control, 104

Search All facility, 269 ‚ 276

Search box (Object Browser), 134

Search facility (Excel), 269

Searching for a character, 220

Searching multiple sheets and workbooks, 269 ‚ 276

Searching strings, 46 ‚ 47

Second function, 59

Select Case statements, 36 ‚ 37

Select method (Range object), 158

Select method (Worksheet object), 154 ‚ 155

SelectedSheets collection, 152, 207

SelectedSheets object, 218, 220, 247, 283

Selection object, 140, 207

Selection property (Application object), 145

Semicolon (;), for separating format strings, 52

SendKeys command, 60 ‚ 63

coding special characters , 62 ‚ 63

value of wait parameter, 61

Set statement, 137, 292

SetBackGroundPicture method (Worksheet object), 155

Shadowing of variables, 15

Shape of comments, changing, 280 ‚ 285

Shape Height and Width properties, 285

Shapes, VBA-defined, 291 ‚ 293

Shapes available in Object Browser, 280

SheetChange event (Workbook object), 129

Sheets collection, 146, 230

Shell function, 61

Show method, 97, 243, 266, 289

Single quote (') character, 9, 207 ‚ 208, 296

Single Step, 81

Single stepping (debugging), 81

SLA (Service Level Agreement), program to populate, 163 ‚ 164

Sorting worksheets into alpha order, 229 ‚ 230

Sounds, playing from within code, 192

Special characters for use with SendKeys, 62 ‚ 63

SpinButton control, 104 ‚ 105

Split property (Windows object), 152

Splitting strings, 44 ‚ 45

Sqr function, 48

Square brackets [], for optional parameters/properties, 131, 135

Standard Excel spreadsheet screen, 4

Standard Visual Basic window, 5

Start parameter (Instr function), 46

Statements, indenting of, 7

Static Collection object, creating, 198

Static keyword, 14 ‚ 15

Static variables, 14 ‚ 15

Step Into (in debugging), 80 ‚ 81

Step (keyword), in For..Next loops , 38

Step Over (in debugging), 80

Stepping through code, 80 ‚ 81

Stop statement, 80

Storing data while code is executing, 12

String data types, 19

Strings, 43 ‚ 47

changing the appearance of, 45 ‚ 46

changing to lowercase, 46

changing to uppercase, 45

comparing, 75

concatenating, 43 ‚ 44, 71

explained, 43

removing characters from, 232

replacing characters in, 231 ‚ 233

searching, 46 ‚ 47

setting to Null, 214

splitting, 44 ‚ 45

user -friendly messages as, 44

Sub (keyword), 27

Subroutines

vs. functions, 26

public and private, 30 ‚ 31

writing, 27 ‚ 28

Subtract (-) operator, 69

SUM formulas, 239 ‚ 240

SUM function, 257

SUMCELLSBYREF function, user-defined, 255 ‚ 258

SUMCELLSBYREF function attributes, 256

Summing cells by reference to format, 255 ‚ 258