Index_N

N

name As vartype form, 90

Name command, 304

Name field, 13

Name objects, 184, 639, 834

Name property, 20, 126, 127, 153, 154, 196, 217, 221, 272, 293, 302, 668

!Name property, 667, 668

named parameters, 105-6

NameLocal property, 196

Names method, 192

Names object, 834

Names.xls file, 192

naming variables , 87

nested data field, 95

nested procedures, 383

networked data, 573

New button, 579

new functions in Excel 2000, 237

New keyword, 161

New Macro command, 82

NewFont object, 834

newMyClass function, 165

NewSheet event, 157

NewWindow method, 217

NewWorkbook event, 151-52, 156

nextUpdateTime variable, 358-59 n:m relation, 622-23

nnnn.xls file, 684

"No header row" button, 581

(NonBlanks) setting, 583, 584

Northwind database, 625, 625-26

Not operators, 178

notes, in cells , 193

NoteText method, 193

Nothing result, 589

Notify Before State Loss option, 74

Now function, 250, 253, 265, 266

NOW( ) method, 578

nrOfFiles file, 684

NULL comment, 659

Null value, 89, 235

NumberedWeekday function, 259-60

NumberFormat property, 195, 196, 197, 199

NumberFormatLocal property, 195, 196, 199, 347-48

numbers , 232-35

absolute value of, 234

Excel worksheet functions, 232-35

and format functions, 242-43

fractional part of, 234

random, 234-35

rounding, 233

special functions, 235

syntax summary, 243-46

transforming character strings into, 241-42

transforming into character strings, 242

trigonometric, exponential, and logarithmic functions, 234

NumberToText function, 314-15

numerical input, programming techniques for, 447-48

NumericScale, field property, 668

nwind1, ˆ’ 2 worksheet, 710

nwind-data worksheet, 710, 711

nwind-link worksheet, 710

Nwind.mdb database, 647

Nwind.mdb file name, 722