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

25 votes282 views3 answers
String to date vb
VBA
0 vote108 views1 answer
Vba set vs dim
VBA
0 vote140 views1 answer
Do until vb.net
VBA
3 votes144 views1 answer
Excel vba read registry key value
VBA
15 votes200 views1 answer
Excel vba wait
VBA
1 vote160 views1 answer
Excel date to unix timestamp
VBA
6 votes158 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote154 views1 answer
Vba integer to double
VBA
0 vote162 views1 answer
Excel vba set cell value to empty
VBA
0 vote143 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA