I'm getting an error 13: Type Mismatch, and I'm not sure why.
This is the piece of code that seems like is creating the problem:
and it's the last if...then statement that is giving the type mismatch error, where activecell.offset(count-1,0) >= activecell.offset(count-1,1) is comparing two cells containing integer values and the timevalue function is comparing now() to the time value in activecell.offset(count-1,8) + 24hours. I see that the problem might come first setting the cell to 0 in the first if...then statement, but what else could I declare that cell first that would be possible to put into the timevalue function so it's the same type?
Thanks in advance,
Cruzader
Bookmarks