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 vote336 views1 answer
Vb.net change cursor to wait
VBA
1 vote342 views1 answer
Vbs run
VBA
1 vote346 views2 answers
Vba function return array
VBA
0 vote350 views1 answer
Vba test optional argument
VBA
0 vote348 views1 answer
VBA Loop to range
VBA
0 vote348 views1 answer
Vba open report
VBA
0 vote329 views1 answer
Excel vba extract year
VBA
0 vote341 views1 answer
VB get external IP address
VBA
0 vote357 views1 answer
Excel vba protect worksheet without password
VBA
0 vote331 views1 answer
Excel vba copy entire sheet paste values
VBA