ByRef type Mismatch error with RegEx

Hi All,

I'm getting a "ByRef argument type mismatch" error in my code. I don't quite understand how this is happening, since I thought the Regular Expression will still work with a string. Below are the relevant snippets of code.

Please Login or Register  to view this content.

Wondering if someone can help me out. This place has always been great.

Thanks!
1980

Try changing below line...

Please Login or Register  to view this content.

To...

Please Login or Register  to view this content.

Edit: And dim FlexValue as string.

Ah, crap. Thanks! I didn't want to use a different variable for dates, but it looks like I'm going to have to.

Thanks for the help.

1980