vba excel calling an array within a Find function

I have:

Please Login or Register  to view this content.

I create my array within another routine which prints correctly, however, I get a type mismatch error thrown when I call the array value within a Find function as a string value. I usually don't have problems trying to find a string values this way, but for some reason using the array value bombs it. What am I doing wrong here?

Thanks. That seems to fix a part of it. My fStart is still Nothing when the string value exists within rng.

I seemed to have solved my own question. I just needed to ensure I was using apples to apples. I was searching for a date however the variable was declared as a string. Using the CDate function solved the problem by converting the string to a date value. The original value (within A:A) was delimited from a string; however, when looking at the previous routine that parses the string, range B:B was defined as "mm/dd/yy;@" (range C:C was defined as "h:mm:ss;@"). I tried using DateValue(string) but that did not work because the string value had not been converted to date and DateValue() assumes there is h:mm:ss within the date string.

Please Login or Register  to view this content.