V

validating data

pasted data, 187

in shared workbooks, 792

validation statistics in linear regression, 561

value axes

assigning secondary, 653

in charts, 625

intersection, 647–648

reversing, 645

scale of, 644–645

tick marks, 642, 644

#VALUE error, 438

#VALUE errors, 682

#VALUE! errors, 851, 854

VALUE function, 988

values. See also FALSE value; TRUE value

CHOOSE function and, 516

converting Euros, 549–551

displaying PivotTable details, 741–742

filtering in PivotTables, 730–731

finding largest or smallest, 554

finding most frequent, 554

formatting, 188

pasting, 185, 187, 188, 787

in queries, 761–762

returning smallest and largest, 557

in scenarios, 588–590

seed, 576

sorting and, 682

VAR function, 558–559, 732, 988

VARA function, 556, 988

variable declining balance depreciation, 543

variables. See also changing cells

in custom functions, 850

declaring, 861–862

displaying in reports, 595

displaying values in Immediate window, 866

misspelled names, 861–862

monitoring values of, 862

values of, 861

Watch Window, 865

variances, 558–559, 569

VARP function, 558, 559, 732, 988

VARPA function, 556, 988

 VAR.xlsx file, 558

VBA (Visual Basic for Applications). See Visual Basic for Applications (VBA)

VDB function, 543, 988

vector form arguments, 513, 515

versions of documents

Excel Services, 821

SharePoint sites, 808

vertex handles on shapes, 351–352

vertical axes, 625

vertical page layouts, 403

vertical position, 512–515

View menu commands and options, 910–912

View tab commands and options, 907, 910, 912, 917, 921, 923

viewing. See displaying

visceral feedback, 100

visible cells, 133

Visual Basic Editor

accessing Excel functions in, 851

adding custom functions to library, 856–857

assigning macros to objects, 394–395

breakpoints, 863–864

collections, 838–839

custom functions, 847–848

debugging tools, 859–866

editing macros, 841–843

Help, 835

Immediate window, 866

keywords in custom functions, 851

misspelled variable names, 861–862

Object Browser, 836–837

overview, 833–835

stepping through code, 862–863

subroutines, 843–845

Watch Window, 245, 865

writing macros, 846

Visual Basic for Applications (VBA)

accessing Excel functions in, 851

arguments for methods, 840–841

breakpoints, 863, 864

by-name and by-position syntax, 840–841

collections, 838–839

compiler, 859–861

debugging, 859–869

documenting macros and custom functions, 851–852

editing VBA code, 95

enabling macro execution, 827–830

further readings, 859

keywords in custom functions, 851

macro recorder and, 846

macros, defined, 827

manipulating object properties, 840

misspelled variable names, 861–862

Object Browser, 836–837

objects, methods, and properties, 835–837

programmatic access to documents, 805

stepping through code, 862–863

subroutines, 843–845

VBA-enabled workbooks file format, 57

Visual Basic Editor and, 833–835

Watch Window, 245, 865

VLOOKUP function, 512–515, 988

volatile functions, 532, 575