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 vote223 views1 answer
Vb window.minimize
VBA
5 votes249 views1 answer
Xl vba double quotes in string literal
VBA
0 vote205 views1 answer
Excel vba concatenate range
VBA
12 votes283 views1 answer
Excel vba write string to text file
VBA
0 vote239 views1 answer
Do while not vb.net
VBA
0 vote196 views1 answer
How to sort datagridview in vb.net
VBA
7 votes234 views1 answer
Excerl vba array to range
VBA
0 vote213 views1 answer
Vbnet add new ecel sheet
VBA
0 vote234 views1 answer
Excel vba chrw max value
VBA
0 vote280 views1 answer
Excel vba delete columns in range
VBA