#.resize excel vba how to#
How to create an array ? 5.1 Method 'Array' 5.2 Method Split 5.3 Declare the variable 5.3.1 How to declare 5.3.1.1 1-dimensional: fixed size 5.3.1.2 2-dimensional: fixed size 5.3.1.3 1-dimensional: dynamic 5.3.1.4 2-dimensional: dynamic 5.3.2 Scope and location 5.3.2.1 Scope 'Local' 5.3.2.2 Scope 'Private' 5.3.2.3 Scope 'Public' 5.3.3 Variant or Array 5.3.3.1 Variant variable 5.3.3.2 Array variable 5.3.4 Declare the content 5.4 Object properties 5.4.1 Range in Excel 5.4.1.1 2-dimensional array 5.4.1.2 1-dimensional array 5.4.2 ActiveX-control 5.4.3 Method 'Evaluate' 5.4.3.1 1-dimensional array 5.4.3.2 2-dimensional array 5.4.4 Dictionary 5.4.4.1 1-dimensional array 5.4.4.2 2-dimensional array 5.5 The argument ParamArray 6.
What is an array 2 Array names 3 Kinds of arrays 3.1 1-dimensional 3.2 multi-dimensional 4 Properties 4.1 Lower limit: Lbound 4.2 Upper limit: Ubound 4.3 Array type: Vartype 4.4 Array TypeName 4.5 IsArray 4.6 ReDim 4.7 Erase 4.7.1 Variant containing array 4.7.2 Dynamic array 4.7.3 Fixed size array 5.
0 kommentar(er)
