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

0 vote261 views1 answer
Priavte sub with multiple handels find sneder
VBA
5 votes254 views1 answer
Excel vba low word from Long Integer
VBA
1 vote228 views1 answer
Vba reverse string
VBA
0 vote245 views1 answer
Vba listbox remove all items
VBA
0 vote229 views1 answer
Excel vba clear filter
VBA
0 vote249 views1 answer
Filesystemobject vba reference
VBA
0 vote207 views1 answer
Vbnet make a string to unicode converter
VBA
1 vote236 views1 answer
Excel vba saveas force overwrite
VBA
5 votes253 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote249 views1 answer
How to get the value of optionbutton in vba
VBA