Info

solution, 506-507 summary, 516 WiringToExcelCoords()

function, 509 Workbook_SheetChange

Workbook_Sheet-SelectionChange() function, 511-512 XLtoWiringCoords() function, 509 help buttons, 427-429 hyperlinks, running macros from, 495-496 Importlnvoice macro, 56-58 named ranges for

VLookups, 139-140 password checking, 477-478 R1C1 references, 121 Word custom reports, 373-376 cbConfirm_Click() function, 409

cbSubAll_Click() function, 212, 220

cbSubClear_Click() function, 212, 220 cell progress indicator, 319-320

CellColor function, 84-87

cells

A1 references, 117 adding based on interior color, 83-84 blank cells, deleting from pivot tables, 245-246 cell progress indicator,

319-320 colors, 84-87

comments centering, 305-306 listing, 303-304 placing charts in,

306-307 resizing, 304-306 empty cells, checking for, 69-70

first non-zero-length cell, finding, 91 highlighting, 308-309 non-contiguous cells,

311-313 R1C1 references absolute references,

122-123 advantages of, 117-120 case study, 121 column numbers, remembering, 125-126 conditional formatting,

126-129 displaying, 118-119 entire columns/rows, referencing, 123 mixed references, 123 multiplication table example, 124-125 relative references, 121-122 reversing contents of, 99 selecting with SpecialCells, 71-73, 324-325 Cells() function, 62

Cells property (Range object), 64-65 centering comments, 305-306

Centering command

(UserForm toolbar), 433 Change() event, 150

changeAConnectionO

function, 512 ChangeFormat() function, 369-370

ChangeStyle() function, 370 Chart_Activate() event, 153

Chart_BeforeDoubleClick()

event, 154 Chart_BeforeRightClick() event, 154

Chart_Calculate() event, 154 Chart_Calculate() function, 202

Chart_Deactivate() event, 154

Chart_DragOver() event,

0 0

Post a comment