Run-time error -2147417848 (80010108) Method Value of object Range failed

[Arito]

Hi,

I have VBA code like this:

Please Login or Register  to view this content.

The formula in O2 is: "=IFERROR(IF(OR(M2="OFF",L2<=N2),0,L2),0)" (the iferror statement is to make sure it returns no errors). Usually this code runs fine but sometimes it crashes on the first row giving the error in the picture attached. error.jpg If I press "debug" the popup will come again and if I choose "end" Excel crashes (quits).

I don't see any strange value in O2 when it happens. I'm 100% sure there was a 0 in there the last time I saw the vba error. I don't understand why it's crashing as the entire code is:

Please Login or Register  to view this content.

Which works fine and it's duplicated in a different duplicate tab as well which also works fine.

Any help would be appreciated.

[Obsessed]

It looks like the active workbook is the DTX workbook...try using Thisworkbook.Worksheets rather than calling it out. I've had weird errors clear up after changing the way I reference cells.