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

3 votes309 views1 answer
Vba post request json
VBA
0 vote270 views2 answers
Excel vba protect cells with formula
VBA
0 vote283 views1 answer
Vb ternary
VBA
2 votes275 views1 answer
Excel vba check if string entirely numeric
VBA
0 vote272 views1 answer
VBA Loop to range
VBA
0 vote292 views1 answer
Vba remove the first character of string
VBA
0 vote282 views1 answer
Excel vba unlock sheet without password
VBA
0 vote278 views1 answer
Delete rows in excel vba code
VBA
0 vote279 views1 answer
Vba table header name
VBA
0 vote259 views1 answer
Putting marquee in vb.net
VBA