Run-Time error not showing up in Debug

[cbarton]

Hola,
I've got a pretty long macro that throws a Run-Time Error when ran, but does not error out when I debug and step in the code. I've got lots of cell value evaluations and its probably a Null value causing it, but I need a way to confirm. I'm about to create a log worksheet and just write to it after each section of my code, unless someone has a better idea. Thanks in advance.

 

[cbarton]

Just added Log worksheet and wrote to it and found my code that was causing an error. I'd like to find out what I did wrong so I can avoid the issue in the future. The line was:

If i.Range("AB" & j).Value <> "" Then

This is part of a loop and it would run through 86 records and then error out. I checked the value of this specific record and there is nothing different than any records before or after it. Could this be caused by a cell formatting issue? I replaced all the Null values in Column AB with XX and changed code to:
If i.Range("AB" & j).Value <> "XX" Then

...and then it ran fine. Where is my mistake?

 

[sky1in5]

If iserror(i.Range("AB" & j).Value) = false Then

'your code

end if