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 vote218 views1 answer
Convert number to minutes in vba
VBA
1 vote206 views1 answer
Excel vba get ordinal number from cardinal number
VBA
3 votes237 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote216 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote162 views1 answer
Excel vba arrondir
VBA
31 votes499 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote213 views1 answer
Telephon call in vba
VBA
3 votes253 views1 answer
Excel vba make long from two shorts
VBA
0 vote251 views1 answer
Vbnet add axis labels to chart
VBA
5 votes234 views1 answer
Excel vba first byte from INTEGER
VBA