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 vote216 views1 answer
Returns an array from function vba
VBA
0 vote214 views1 answer
Vba get workbook name
VBA
0 vote219 views1 answer
Vba option button selected
VBA
0 vote212 views1 answer
Vba remove last vbcrlf
VBA
-1 vote201 views1 answer
For i in range vba
VBA
5 votes229 views1 answer
Excel vba low word from Long Integer
VBA
1 vote221 views1 answer
If inputbox cancel vba
VBA
1 vote204 views1 answer
Excel vba hide zero values
VBA
0 vote220 views2 answers
Excel vba number format file size
VBA
3 votes232 views1 answer
Excel insert blank row for value change in column
VBA