I have a function where a string and a string-based array are passed in.
Using the VBE Watch function I can see the string passed in is:
The array contains:
The line:
is resolving to False, in other words it's skipping to the Else part, even when intCount = 0 or 1.
However if I run it when the string and array contain "TD1" it works fine.
Seems like either the /, space or & are causing issues?
Also posted here: http://www.ozgrid.com/forum/showthread.php?t=200657&p=774921#post774921
Using the VBE Watch function I can see the string passed in is:
Code:
TD1a/b/ PMO & CT
The array contains:
Code:
TD1a/b/ PMO & CT
TD1a/b/ PMO & CT
""
The line:
Code:
If staffName = whichArray(intCount) Then
is resolving to False, in other words it's skipping to the Else part, even when intCount = 0 or 1.
However if I run it when the string and array contain "TD1" it works fine.
Seems like either the /, space or & are causing issues?
Also posted here: http://www.ozgrid.com/forum/showthread.php?t=200657&p=774921#post774921
Last edited: