vba dim according to dynamic variable code example
Example 1: 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
Example 2: vba dim multiple variables
Dim a As Single, b As Single, c As Single