VBA Parameters

Most VBA functions require you to supply one or more parameters. Table 13 lists the parameter types and the valid values for each type:

Table 13. VBA Parameters

Parameters	Values
Text	A word or phrase or name in quotes. For example: Smart View [Book2.xls]Sheet1
Boolean	True False
Range Object	A cell, row or column, one or more selections of cells, or a three-dimensional range address, surrounded by quotes. For example: RANGE(“A1”) RANGE(“A1:B2”) RANGE(“A1:B2”) RANGE(“G:G,I:I,K:K”) RANGE(“A1:B5,C1:C10,D5:L8”) RANGE(“Sheet1!C3:R20,Sheet2!C3:R20”)
Number	A number without quotes and without commas. For example: 1 2.5 50000
List of Strings	A list of text values, separated by commas. For example: “Qtr1”, “Actual”, “Oregon”
Constant	A predefined constant from smartview.bas.
Default Value	Null Empty Note: Many parameters have default values or behavior that the function uses if you specify Null or Empty. If you do not specify a value for such parameters, use Null or Empty. See the description of each function for default values of such parameters.