配列

Excel VBA Sample

VBA 一次元配列のソート

バブルソート隣同士の値を比較、必要があれば入れ替えを繰り返して整列するVBSub zsBubbleSort1(ByRef dataAry() As Variant) Dim temp As Variant Dim i As Long, j ...
Excel VBA Sample

VBA 配列の中に配列を入れてみた

VBSub 配列test() Dim i As Long, j As Long Dim arr1 As Variant Dim arr2 As Variant Dim arrAll(2) As Variant arr1 = Range("A...
Excel VBA Sample

VBA 戻り値を配列

VBFunction zf配列を戻り値(ByVal dataStr As String) As Variant() Dim returnArr() As Variant Select Case dataStr Case "あ" return...
Excel VBA Sample

VBA 2次元配列の1次元目の要素数を変更

Transpose関数を利用VBOption Base 1'*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-'★2次元配列の1次元目の要素数を増やす (Transpose利用)'*-*-*-*...