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 vote246 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote272 views1 answer
How to call gcd in vba
VBA
0 vote269 views4 answers
Jwt token vb.net validation
VBA
6 votes237 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote218 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote237 views2 answers
Excel vba number format file size
VBA
4 votes227 views1 answer
Excel vba how to reset usedrange
VBA
-1 vote261 views1 answer
How to correct a number to 2 decimal places in vba
VBA
2 votes227 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote236 views1 answer
Vba string
VBA