What is wrong with this VBA CODE

[steve1d]

What is wrong with the following code :

If C.SentOn <> "" Then

It keeps erroring. The same code runs perfectly in other modules.

[Seth Schrock]

If C.SentOn is null, then you will get an error because you can't compare null to anything. If this is the problem, then the fix would be

If C.SentOn & "" <> "" Then

By concatenating a zero-length string to C.SentOn, you make it not null without changing the value that you are comparing.

[NeoPa]

I'm sure if the code errors then it will give number and description information about the particular error. This essential information is missing from your question for some reason.