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

18 votes353 views3 answers
Excel-vba make integer
VBA
1 vote180 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
1 vote188 views1 answer
Sort using vba
VBA
0 vote154 views1 answer
How to make a if statement with vbs
VBA
0 vote219 views1 answer
Winforms dark title bar
VBA
0 vote183 views1 answer
Change form background image vb
VBA
5 votes193 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote168 views1 answer
Vbs exec hidden
VBA
0 vote179 views1 answer
Vba code for cutoff time
VBA
0 vote183 views1 answer
Como ler subitem de um array em json usando vbnet
VBA