Answers for "vba set vs dim"

VBA
1

vba multiple dim

Dim a, b As Integer
' is equivalent to
Dim a As Variant, b As Integer

' Declare a and b as Integer:
Dim a As Integer
Dim b As Integer
' Or:
Dim a As Integer, b As Integer
Posted by: Guest on February-13-2021
0

vba dim and set value

' More visual (':' is just a line separator)
Dim sTest As String:  sTest = clientsToTest(i)
Dim sVariant As Variant: sVariant = Split(sTest)
' Objects
Dim ws as New Workbook
Posted by: Guest on January-26-2021

Code answers related to "VBA"

Browse Popular Code Answers by Language