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 vote165 views1 answer
Openfiledialog specific folder
VBA
1 vote155 views2 answers
Vba remove first 2 characters from string
VBA
3 votes175 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
1 vote162 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
1 vote165 views1 answer
Excel vba get column name from number
VBA
0 vote172 views1 answer
.net dark title bar
VBA
1 vote161 views1 answer
Add control vb
VBA
0 vote194 views1 answer
Excel vba unlock sheet without password
VBA
0 vote155 views1 answer
Excel vba center userform
VBA
8 votes242 views1 answer
Excel vba determine number of elements in a 2D array
VBA