What do you want to save?
Add Code snippet
New code examples
-
VBA 2021-10-18 19:05:10
vba string array
'In VBA a dynamic string array is declared in the following ways: Dim strArr1() As String Dim strArr2$() 'Neither declaration style is prefered. They are exactly equivalent. 'Both ways above produce a dynamic array, which means that the exact size of '... 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
Best helpers
Ranking is empty