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 vote350 views1 answer
Excel vba DisplayAlerts
VBA
22 votes547 views1 answer
Xl vba check for folder
VBA
3 votes326 views1 answer
Vba make long from two shorts
VBA
0 vote354 views1 answer
Style percent not found vba
VBA
0 vote335 views1 answer
Convert number to minutes in vba
VBA
0 vote343 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote326 views1 answer
Vba option button selected
VBA
0 vote296 views1 answer
Add items to combobox vb.net
VBA
0 vote340 views1 answer
Vba round to 2 decimals
VBA
0 vote335 views1 answer
Excel text to columns line break
VBA