L
LabelMonths macro, 116-17
labels filling, 33-37 in formulas, 211 in macros, 179
LargeChange property, 215
large loops, 155-60
Last Position command, 115
layout, PivotTable reports, 264-71
LineStyle property, Borders object, 102-3
LinkedCell property, 222
list boxes. See ComboBox object
ListFiles macro, 153-55
ListFillRange property, 219
lists, enumerated, 104
Loan Payment Calculator creating, 210-11 making error-resistant, 212-16 trying out, 211-12
Locals window, 57
logic errors, 170
logos animating, 281-84 creating in WordArt, 279-81
loops. See also conditionals breakpoints in, 155-58 in CompareCells macro, 150-52 displaying progress, 159-60 Do loop (see Do loop) For Each structure, 149-50 For loop (see For loop) infinite, 155 large, 155-60 in ListFiles macro, 153-55 overview, 149 in ProtectSheets macro, 152-53 in UnprotectSheets macro, 150
Loop statement, Do loop |