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 vote296 views1 answer
Loop through lines in text file vb net
VBA
5 votes327 views1 answer
Xlvba double quotes in string literal
VBA
0 vote290 views1 answer
Vba html document reference
VBA
0 vote278 views1 answer
Vb check if row has column
VBA
0 vote313 views1 answer
Vba count all row
VBA
0 vote296 views1 answer
Vba listbox remove all items
VBA
0 vote295 views1 answer
Excel vba unlock sheet without password
VBA
0 vote288 views1 answer
Excel vba round to whole number
VBA
2 votes272 views1 answer
Excel vba extract file name
VBA
0 vote290 views1 answer
Weekday vba
VBA