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 vote172 views1 answer
Freeze panes vba
VBA
0 vote174 views1 answer
Ribbon show/hide
VBA
0 vote167 views1 answer
Vba get workbook name
VBA
0 vote173 views1 answer
Excel named range sum
VBA
0 vote165 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote155 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote175 views1 answer
Excel vba first working day month
VBA
4 votes180 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote212 views1 answer
Wpf dark title bar
VBA
0 vote164 views1 answer
Excel vba select multiple shapes
VBA