Run-Time Error '13' Type Mismatch

Here' the segment of my code

Please Login or Register  to view this content.

Video illustrating the error: http://screencast.com/t/xCx1jOdLk

I have everything printed and my code works until i hit one particular row...!?

I have tested it without the part highlighted in red and no errors pop-up. So what is making this temperamental?

TimeSerial has limits... which row number?

Originally Posted by cytop

TimeSerial has limits... which row number?

The MATCH should return row number 6285

Originally Posted by Winon

Hello domgilberto,

Try:

Please Login or Register  to view this content.

Regards.

Putting "z" in won't help. It actually makes it worse as I depend upon the increase in "w" to increment my date and time by 1 hour each successive loop

What other ways can i simply add an hour to my date time... this is so annoying

Nope - doesn't help...

Man this is killing me... Writing the MATCH in excel formula it grabs what i need... Why is it working on every row and then it bombs out on a specific row with this run-time error!

The function itself works - what may not work is how you use it, or the logic of what you are doing.

Nope - doesn't help

Really doesn't help.

Originally Posted by cytop

The function itself works - what may not work is how you use it, or the logic of what you are doing.



Really doesn't help.

Ok so I've been spending hours on this issue now. Basically this:

Please Login or Register  to view this content.

Creates a bug and the run-time error in question. If I remove the "0" argument from the Application.Match it works (but obviously this is not correct as without this it assumes a "1").

So my theory is that my date times ("m/dd/yyyy hh:mm") is marginally incorrect and there is a precision issue going on here. E.g. the serial value this part:

Please Login or Register  to view this content.

Does not PRECISELY match up because of a rounding issue?

Any ideas on how i can test this?