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 vote206 views2 answers
Excel vba prevent save
VBA
0 vote221 views1 answer
Vba collection key list
VBA
0 vote233 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote202 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote234 views1 answer
Vba html document reference
VBA
3 votes268 views1 answer
Excel vba make long from two shorts
VBA
0 vote227 views1 answer
Excel vba unmerge sheet
VBA
1 vote213 views1 answer
Vba reverse string
VBA
0 vote225 views1 answer
String contins in vba
VBA
20 votes510 views1 answer
Excel vba recursive example factorial function
VBA