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

3 votes357 views1 answer
Vba continue for each loop
VBA
0 vote316 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote341 views1 answer
Vbnet convert charatcer to binary
VBA
0 vote331 views1 answer
Excel filter by date not working vba
VBA
0 vote333 views1 answer
Vba variable number of arguments
VBA
0 vote332 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote302 views1 answer
Vbnet dynamically change excel sheet name
VBA
3 votes337 views1 answer
Vba make long from two words
VBA
0 vote351 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote355 views1 answer
Excel vba convert cells address
VBA