Date Confusion

[Programmernovice]

I have 2 macros operating on the same data, as shown on attached BookX on 2 separate, unlinked workbooks. The first macro contains the line

Please Login or Register  to view this content.

The second contains the line

Please Login or Register  to view this content.

They are clearly identical. The first one runs perfectly on the first workbook. The second gives the "Type mismatch error" at that line, for the second workbook's identical data.

Any idea how to remedy? All help appreciated, the problem is really confounding.

[alansidman]

There is no code in your workbook

[Programmernovice]

I have attached the workbook containing the code. I'm find that apparently the other 3 conditions somehow interfere with the date condition. Separating it from the rest appears to help
Thanks.

[alansidman]

Has this been solved based upon your last post?

[Programmernovice]

I'm afraid not. I thought that separating the date condition from the other 3 might work. It doesn't appear to work. The problem is the presence of the date condition. The other 3 work fine.

Any ideas for a workaround are greatly appreciated.

[alansidman]

Try this:

Please Login or Register  to view this content.

[Programmernovice]

Many thanks. I did 2 similar things:

1.- I kept the first 3 conditions together as an OR statement.
2.- I inserted the 4th condition into a new line, just as you did, and change DateValue to CDate.

It appears to have worked.

I will also try yours, maybe it speeds up the macro. Importantly, can you think of any reason why this is the case? Maybe 4 conditions are not allowed in one OR line?

As always you have been very helpful, thanks.