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

32 votes315 views2 answers
Excel vba column letter
VBA
0 vote173 views1 answer
Vb.net change cursor to wait
VBA
0 vote169 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote166 views2 answers
Vba find last row in range for certain criteria
VBA
0 vote181 views1 answer
.net crash app
VBA
0 vote160 views1 answer
Excel vba show developer tab
VBA
5 votes182 views1 answer
Xlvba double quotes in string literal
VBA
8 votes300 views1 answer
Vba convert 2 bytes to an integer
VBA
5 votes113 views1 answer
Vlookup vba
VBA
3 votes163 views1 answer
Excel vba read registry key value
VBA