Vba set vs dim

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

Source: grepper.com

Similar codes

1 vote202 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
1 vote185 views1 answer
Extract the second word in a text in excel
VBA
1 vote185 views1 answer
Vba loop through files in folder
VBA
3 votes181 views1 answer
Vba double quote
VBA
0 vote174 views1 answer
Vbnet check if number is even or odd
VBA
0 vote188 views1 answer
Vba first cell in range
VBA
0 vote207 views1 answer
How to enter Vbox manage commands
VBA
0 vote165 views1 answer
Remove frist letter from string vbnet
VBA
0 vote184 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote187 views1 answer
Find database connection string vb
VBA