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 vote230 views1 answer
Excel vba get column number from column name
VBA
0 vote243 views1 answer
Columns dont autoresize on program start vb.net
VBA
1 vote211 views2 answers
Vba remove first 2 characters from string
VBA
0 vote293 views1 answer
Application.ExecutablePath VB.NET
VBA
5 votes240 views1 answer
Xlvba double quotes in string literal
VBA
0 vote230 views1 answer
Excel vba automatic calculation
VBA
0 vote236 views1 answer
VB Error Code BC30201
VBA
1 vote252 views1 answer
Excel vba first row in range
VBA
0 vote228 views1 answer
Show unix time in vba
VBA
0 vote243 views1 answer
Vba round to 2 decimals
VBA