How to compare time values in different cells - type mismatch

Hi,

I'm sure this is really simple but I just can't get the syntax right and google has not come to my aid.

I have some code which compares the value in a cell to a timeserial value to determine if the time is before or after 4pm them asigns the result to a boolean variable (true or fasle).

I want to alter the code to compare to another cell value rather than a hardcoded time serial (ultimately for a bit of future proofing to allow the users to change the '4pm' value if need be.

The first line of the If statement below is what I have at the moment which doesn't work and the Esleif line is as it was before which works - just so you can see what I mean:

Please Login or Register  to view this content.

I've tried .value, encasing in TimeValue, etc, but can't get it quite right. The value in the first cell is 0.4652777...778 and in the named range 0.666666...667 (checked in the imediate window) so not sure why it can't compare them...

Any help appreciated, as always. TC

Apologies for not coming back straight away - I finish work a bit earlier on a Friday.

Anyway, I looked at this with fresh eyes today and it works perfectly - looks like I was just being a bit of a numbnuts!

Here's the code that works in case anyone is interested:

Please Login or Register  to view this content.

Norie - the TimeIDCol is a named range containing the column number of the TimeID column (I have a series of ranges that are populated with column and row numbers on the workbook open event).

Thanks for responding anyway. TC