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 vote131 views1 answer
Type excel.application is not defined vb
VBA
22 votes272 views1 answer
Xl vba check for folder
VBA
0 vote143 views1 answer
Sort dictionary by key vba
VBA
0 vote129 views1 answer
Afficher un message d'erreur vba
VBA
0 vote138 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote138 views1 answer
Vba integer to double
VBA
4 votes138 views1 answer
Excel vba how to reset usedrange
VBA
-1 vote145 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote135 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote136 views1 answer
Check range is in another range vba
VBA