When trying to use a formula, I get the error message "Can't find project or library",
after I press OK, a box called "references - VBAProject" pops up, listing all avaliable references.
I can't figure out what to do next. The references are just listed, -can't see where the problem lies.
I've looked around a bit on different help forums, and usually the case with these errors is that some references are listed as 'MISSING'.
But that's not the case here.
Nothing seems to be missing. So I can't figure out what to do.
Btw: here's the formula (as in cell S2)
(Basically, if V and D are empty, it should change the value of the S2 cell, writing an 'M' followed by a hexadecimal number based on the numbers in A2 and T2 )=IF(V2="";IF(D2="";IF(E2="AX";E2&A2;"M"&DEC2HEX(HEX2DEC(A2)+1-T2));"");"")
Bookmarks