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

3 votes186 views1 answer
Extract word in a text in excel
VBA
0 vote162 views1 answer
Check range is in another range vba
VBA
0 vote180 views1 answer
Delete all controls in an area vb
VBA
0 vote159 views1 answer
Type excel.application is not defined vb
VBA
0 vote173 views1 answer
Prive sub enter clicked vb
VBA
1 vote183 views1 answer
Perform http request in vb.net
VBA
0 vote155 views1 answer
Excel vba show developer tab
VBA
0 vote111 views1 answer
How to sort datagridview in vb.net
VBA
0 vote176 views2 answers
Excel vba protect cells with formula
VBA
22 votes309 views1 answer
Excel vba check if directory exists
VBA