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 vote182 views1 answer
Excel format cell as kilowatts
VBA
0 vote187 views1 answer
Vba string
VBA
0 vote205 views2 answers
Excel vba number format file size
VBA
3 votes188 views1 answer
Vba make long from two words
VBA
0 vote207 views1 answer
Vba listbox remove all items
VBA
0 vote176 views1 answer
Vb net check if file exists
VBA
5 votes199 views1 answer
Excel vba low word from Long Integer
VBA
0 vote190 views1 answer
How to set location and size of new from vb
VBA
0 vote187 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote193 views1 answer
Excel vba combine ranges
VBA