View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 38
Default VBA Validation between two Times

Thanks again for the help!

Although your code shortens my own considerably it doesn't seem to
solve my problem.

A rundown of what's happening now:

I try pasting this set of data from a different workbook in format
hh:mm
00:00
01:00
02:00
03:00
04:00
05:00
06:00
07:00
08:00
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
17:00
18:00
19:00
20:00
21:00
22:00
23:00

into cell C11

Most of the messages that pop up show as valid, as you would expect
but some cells do not even though the data is correct and the format
is EXACTLY the same.

The below are the ones that paste properly, the ones that show as
invalid and cleared are marked as such

00:00
01:00
02:00
03:00
04:00
Invalid
06:00
07:00
Invalid
09:00
10:00
Invalid
12:00
13:00
Invalid
15:00
16:00
Invalid
18:00
19:00
Invalid
21:00
22:00
Invalid

There is a strange pattern there...

Any further help would be appreciated - I'll be here banging my head
against my desk =)