J
JVLin
Hi,
why do I get a run-time error number 9 'subscript out of range' message on
running this code?
Dim vaTest as variant
Dim i as integer
vaTest = Range("a1:a10").value
For i = 1 to Ubound(vaTest)
If vaTest(i) = "True" then Msgbox "True"
End if
Next i
why do I get a run-time error number 9 'subscript out of range' message on
running this code?
Dim vaTest as variant
Dim i as integer
vaTest = Range("a1:a10").value
For i = 1 to Ubound(vaTest)
If vaTest(i) = "True" then Msgbox "True"
End if
Next i