Page 12 - Excel for Scientists and Engineers: Numerical Methods

CONTENTS ix

Working with Arrays in Sub Procedures:
Passing Values from a VBA Module to a Worksheet ................................ 45
A One-Dimensional Array Assigned to a Worksheet Range
Can Cause Problems ................................................................................... 46
Custom Functions ................................................................................................. 47
Specifying the Data Type of an Argument .................................................... 47
Specifying the Data Type Returned by a Function Procedure ....................... 47
Returning an Error Value from a Function Procedure ................................... 48
A Custom Function that Takes an Optional Argument ................................. 48
Arrays in Function Procedures ............................................................................. 48
A Range Passed to a Function Procedure Can Be Used as an Array ............. 48
Passing an Indefinite Number of Arguments:
Using the ParamArray Keyword ................................................................ 49
Returning an Array of Values as a Result ...................................................... 49
Creating Add-In Function Macros ....................................................................... 50
How to Create an Add-In Macro ................................................................... 51
Testing and Debugging ........................................................................................ 51
Tracing Execution .......................................................................................... 52
Stepping Through Code ................................................................................. 52
Adding a Breakpoint ...................................................................................... 52
Examining the Values of Variables While in Break Mode ............................ 53
Examining the Values of Variables During Execution .................................. 54
Chapter 3 Worksheet Functions for Working with Matrices 57
Arrays, Matrices and Determinants ...................................................................... 57
Some Types of Matrices ................................................................................ 57
An Introduction to Matrix Mathematics ............................................................... 58
Excel's Built-in Matrix Functions ........................................................................ 60
Some Additional Matrix Functions ...................................................................... 63
Problems ............................................................................................................... 66
Chapter 4 Number Series 69
Evaluating Series Formulas .................................................................................. 70
Using Array Constants to Create Series Formulas ........................................ 70
Using the ROW Worksheet Function to Create Series Formulas .................. 71
The INDIRECT Worksheet Function .............................................................. 71
Using the INDIRECT Worksheet Function
with the ROW Worksheet Function to Create Series Formulas ................. 72
The Taylor Series ................................................................................................. 72
The Taylor Series: An Example ..................................................................... 73
Problems ............................................................................................................... 75