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

0 vote437 views1 answer
Wpf dark title bar
VBA
2 votes355 views1 answer
Excel vba check if string entirely alpha
VBA
1 vote326 views1 answer
Excel vba make cell visible
VBA
0 vote355 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote363 views1 answer
Excel vba protect shapes
VBA
0 vote343 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote344 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote337 views1 answer
String contins in vba
VBA
0 vote347 views1 answer
Excel vba ternary
VBA
32 votes527 views2 answers
Excel vba column letter
VBA