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 vote234 views1 answer
Iterate all file in a folder vba
VBA
0 vote203 views1 answer
Vb net check if file exists
VBA
0 vote205 views1 answer
Change whcih control a user has selected vb
VBA
0 vote215 views1 answer
Excel vba StartUpPosition
VBA
1 vote207 views1 answer
Add control vb
VBA
0 vote217 views1 answer
Vba add shape oval
VBA
1 vote220 views1 answer
Add rows to datagridview vb.net
VBA
0 vote207 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote296 views1 answer
Vba change active sheet
VBA
0 vote215 views1 answer
Vba compare strings
VBA