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 vote132 views1 answer
Vba reverse string
VBA
0 vote132 views1 answer
Vba border weight
VBA
0 vote127 views1 answer
Afficher un message d'erreur vba
VBA
1 vote124 views1 answer
Excel vba saveas force overwrite
VBA
0 vote149 views1 answer
How to get value from clipboard in vbnet
VBA
3 votes148 views1 answer
Vba double quote
VBA
1 vote122 views1 answer
How to do error handling in access vba
VBA
0 vote130 views1 answer
Enter into cells data grid view
VBA
0 vote134 views1 answer
Excel named range sum
VBA
0 vote183 views2 answers
VB
VBA