N

named ranges, 62-63

checking existence of, 138 creating, 132-133 deleting, 134 global names, 131 local names, 131 overwriting, 133 VLookups, 139-140

NameExists() function, 138 names, 131

arrays, 136

cell color names, retrieving, 84-87

checking existence of, 138 computer names, returning,

455-456 creating, 132-133 deleting, 134 formulas, 134 global names, 131 hiding, 138 local names, 131 macros, 15 named ranges, 62-63 checking existence of, 138

creating, 132-133 deleting, 134 global names, 131 local names, 131 overwriting, 133 VLookups, 139-140 Names collection, 133 numbers, 136 overwriting, 133 reserved names, 137-138 strings, 135-136 workbook names, 77

Names collection, 133 national debt, tracking, 340-341

nesting

For...Next loops, 107-108 XML tags, 350 NetTransfers() function, 410-411

New statement, 363 New Web Query dialog box, 332-333

NewDocument() function, 365

NewProc() function, 321-322

NewSheet() event, 146 NewWorkbook() event, 157 Next statement, 103-105 no matching records, handling, 224

nodupsArray() function, 90 non-contiguous cells, selecting/deselecting, 311-313

non-contiguous ranges, returning, 74 NoNames() function, 135 NOT statement, 112 Now function, 81

numbers adding, 76-77 column numbers, remembering, 125-126 names, 136

number of workbooks, counting, 79 pivot table number format,

247, 249 random numbers, creating, 101

retrieving from mixed text, 93

sorting, 97-98 week numbers, converting to dates, 94

NumFilesInCurDir() function, 79

NumUniqueValues() function, 88

0 0

Post a comment