What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-03-17 18:05:25
excel vba determine number of elements in an array
'Since VBA arrays can have ANY integer value (from -2147483648 to '2147483647) for the lower index in the range for a rank, 'the only sure fire way to determine how many elements is in the array 'is to calculate the value: MsgBox UBound(Arr) - LBound(Ar... Add solution -
VBA 2021-11-14 02:27:07
excel vba pass array to scriptcontrol
'VBA for passing arrays to and from JScript in the Script Control. 'JScript, running in the Microsoft Script Control, can be 'passed VBA safearrays... exactly the same as Internet Explorer can 'be. But before JScript can do anything with the values in t... Add solution -
VBA 2021-10-29 14:39:13
excel vba determine number of elements in a 2D 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... Add solution -
VBA 2021-10-26 18:02:19
excel vba array sort
'VBA does not include a built-in method for sorting arrays like many 'languages do. 'However, it is easy to have VBA create and use a .NET ArrayList for sorting. '***THE MAJOR REASON TO USE ARRAYLIST IN VBA IS SORTING*** Set arrList = CreateObject(&quo... Add solution -
VBA 2021-09-22 15:37:03
vba static array declaration
'VBA arrays can be fixed-size (static) or resizable (dynamic). 'This is determined when the array is declared: Dim vArrA() 'dynamic: size is determined later. Dim vArrB(1 to 5) 'static: size is determined now and cannot be changed. 'Array size refers ... Add solution