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

20 votes483 views1 answer
Excel vba recursive example factorial function
VBA
0 vote192 views1 answer
Excel vba populate array with cell values
VBA
0 vote206 views1 answer
Dynamic array vba
VBA
1 vote242 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote211 views1 answer
Excel vba combine ranges
VBA
0 vote191 views1 answer
Excel protect cells with formulas
VBA
0 vote190 views1 answer
Excel vba concatenate range
VBA
1 vote194 views1 answer
Excel vba hide zero values
VBA
0 vote211 views1 answer
How to get value from clipboard in vbnet
VBA
1 vote213 views1 answer
Vbs run
VBA