One of my macros has only started working intermittently. I don't get an error message: it simply doesn't return the expected value. Is it possible the macro has become temperamental?
Can you post your code? Or better yet, a sample workbook containing code, source data where code fails to return expected result, as well as the expected result.
If you are getting no error message... chances are pretty good that there's issue with data rather than the code.
