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

4 votes227 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote220 views1 answer
Check range is in another range vba
VBA
0 vote231 views1 answer
Send webhook vbscript
VBA
0 vote252 views1 answer
Vba ternary
VBA
0 vote224 views1 answer
Excel vba saveas no prompt for overwrite
VBA
12 votes274 views1 answer
Excel vba write string to text file
VBA
0 vote223 views1 answer
Excel vba protect content
VBA
4 votes226 views1 answer
Vba create directory
VBA
0 vote232 views1 answer
Excel vba round to whole number
VBA
0 vote226 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA