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 vote164 views1 answer
Excel vba autofit
VBA
1 vote151 views1 answer
Vba delete file
VBA
0 vote172 views1 answer
Vba search string position
VBA
1 vote161 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote157 views1 answer
Excel vba cell on change
VBA
4 votes154 views1 answer
Vba create directory
VBA
1 vote152 views2 answers
Vba string to date
VBA
1 vote147 views1 answer
Textbox find and replace vb
VBA
0 vote163 views1 answer
Check if program is running vbnet
VBA
0 vote153 views1 answer
Enable macros on opening workbook vba
VBA