V

Value property, 120–121, 122

vs. Value2 property, 122

variables, 180

with assigned values, 238

declaring, 123, 180

Empty value, 323

module-level, 278

naming, 143

Nothing value, 323

public, 278

as ranges, 107, 115

spelling errors, checking for, 246

VBA

apostrophes beginning lines in. see comments

green lines in. see comments vs. macros, 2–4

.NET Framework and, 4

object model. see object model

selecting lines in, 17

statements. see statements

vbCrLf constant, 258

View Code button, 267

views

custom, creating, 317–320

switching between, 320–321

viruses, prevention of, 12, 28

Visual Basic editor

Immediate window, 73

opening, 73

windows in, 76–77

volatile functions

defined, 242

recalculating, 242

when to use, 243