Xl vba dynamic string array

'Since VBA arrays can have any integer value for the base element,
'the only sure fire way to determine how many elements is in the array
'is to calculate the value:

MsgBox UBound(Arr) - LBound(Arr) + 1		'<--for elems in 1D array

MsgBox UBound(Arr, 1) - LBound(Arr, 1) + 1	'<--for rows in 2D array
MsgBox UBound(Arr, 2) - LBound(Arr, 2) + 1	'<--for cols in 2D array

Source: academy.excelhero.com

Xl vba dynamic string array

arrayData = Array("A", "B", "C", "D", "E")

[a1].Resize(UBound(arrayData)) = Application.Transpose(arrayData)

Similar codes

1 vote256 views1 answer
Vba optional
VBA
1 vote222 views2 answers
Vba string to date
VBA
0 vote232 views1 answer
Excel vba existence of a file
VBA
0 vote249 views4 answers
Vgrive,deb
VBA
0 vote243 views1 answer
Ribbon show/hide
VBA
0 vote229 views1 answer
Vba parameter adodb null value
VBA
0 vote222 views1 answer
Vba createparameter null
VBA
0 vote240 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote260 views1 answer
Priavte sub with multiple handels find sneder
VBA
0 vote241 views1 answer
Vba sort the data Z to A
VBA