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 vote155 views1 answer
Vba Remove Case Sensitivity
VBA
2 votes149 views2 answers
Vba exit loop
VBA
0 vote210 views1 answer
Vba pass named range to function
VBA
1 vote196 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote204 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote202 views1 answer
Vba string
VBA
1 vote189 views1 answer
Vba compile error object required
VBA
0 vote212 views2 answers
Do until loop vba
VBA
0 vote193 views1 answer
Excel vba milliseconds
VBA
1 vote207 views1 answer
Vbscript convert ascii code to character
VBA