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

1 vote284 views1 answer
Excel vba last column in range
VBA
0 vote280 views1 answer
VBA Sort RossetaCode
VBA
1 vote271 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote287 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote283 views1 answer
Vba change named range address
VBA
1 vote269 views1 answer
Excel vba first and last row and column in range
VBA
1 vote278 views1 answer
Add rows to datagridview vb.net
VBA
3 votes271 views1 answer
Vba request json
VBA
0 vote278 views1 answer
Get current url vb.net
VBA
0 vote282 views1 answer
How to get value from clipboard in vbnet
VBA