Page 476 - Excel for Scientists and Engineers: Numerical Methods

INDEX ~ 45-3

using the Recorder 6 Option Base 1 44,47,5 1
Option Explicit 10
Optional 50
D Or 17,25
Value property 38, 116 ParamArray 5 1 , 52,65
vapor diffusion in a tube (example) Preserve 45
275,277,279,282 Private 31
variable type of an array 44 Public 31
variables 17 Range 37
examining the values of 56 ReDim 45
naming 17 Select Case 25
Variant data type 29 Set 32,43,47
VBA Add Watch dialog box 58 Sheets 32
VBA data types 28,29 Stop 55,56
VBA information functions 23 String 29
VBA keywords 365 UBound 44,51
Address 116 Union 37
And 17,25 Value 38, 116
As 50 VBA mathematical functions 21
Boolean 29 text functions 22
Call 30 VBA, shortcut keys for 387
Cells 36, 37 VBA Watches Pane 58
Chartwizard 35 vector 57
CheckSpelling 35 vibration of a string 282,283
Convertformula 1 17, 1 18 Visual Basic arrays 43
CVErr 50 Visual Basic Editor 1,2, 7
Dim 43,44 Visual Basic procedures 4
Double 29 Visual Basic statements 16
Evaluate 116, 117, 134,225 VLOOKUP worksheet function 77,
Exit 28 79, 80, 81
Formula 116, 133,225 VLOOKUP, use of, in Solver models
If ... Then 25 3 23
If ... Then ... Elself 25
If ... Then ... Else 25 W
InputBox 41 wave equation 264
Integer 29 weights, in Gaussian quadrature 137
Intersect 37 window, properties 1, 5
LBound 44 work-around for the row-column
MsgBox 39 problem 49
Not 17,25 worksheet formula, derivatives of a
NumberFormat 19 110,111,112
On Error GoTo 119 first derivative of a 1 1 1, 1 15