If Then Type Mismatch

Originally Posted by MeggieDoodles

Please Login or Register  to view this content.

I am trying to see if the value in each of the cells in H7:H40 is less than 5 minutes. Anyone know what I'm doing wrong?

I would not expect a "type mismatch" error. But "00:05:00" with quotes is not the way to write "5 minutes" in VBA. (Not even in Excel.)

If cell.Value is numeric time, change "00:05:00" to #00:05:00#. That is, change double-quotes to hash marks. Caveat: VBA might change the appearance of the time constant.

If that does not remedy the problem, I suggest that you attach an example Excel file. Click on Go Advanced to see the Attach File icon in the toolbar.

It all depends on the formatting. With cell formatting as h:mm:ss; this works just fine

Please Login or Register  to view this content.