Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)

/n filename switch, 74

#N/A error, 60

Name command, 830

#NAME? error, 60

name extended property, 839

Name Manager dialog box, 53

Name statement, 980

Named argument not found error, 992

names

cells , 53-54

charts , 579

columns , 55

constants, 56-57

existing references, 54

formulas, 57-59

intersecting, 55

introduction, 30-32

object class, 892

objects, 59

procedures, 239

ranges, 53-54

rows, 55

variables , 193-194

Need property array index error, 991

net present value of an investment, 985

new features

compatibility, 819-820

overview, 19

New Name dialog box, 53

NewSheet event, 638, 640

NewWorkbook event, 656

Now function, 985

NPer function, 985

NPV function, 985

#NULL! error, 60

#NUM! error, 60

number of bytes in a file, 983

numbers

absolute value, 982

arctangent of, 982

cosine, 982

format, 983

integer portion, 983-984

logarithm, 985

rounded, 985

sign, 986

sine, 986

square root, 986

string representation, 986

tangent, 986

numeric formatting, 33

NumLockOn procedure, 891