Quote:
|
Originally Posted by ep2002
LOL, you went right over my head with your formulas, thank gawd your last sentence was in English  . Ok, so I searched the workbook & checked off case & searched both rows & columns separately & nothing.... |
<Chuckle> Ok, forget my long-winded explanations and let's try it this way. Go back to the workbook and:
- Start a Find (<Ctrl-F>).
- In the expanded Options menu, put 'cJ' (mixed case) in the "Find what:" text box.
- Check the "Match case" option (and by "check" I mean turn it on).
- Make sure the "Match entire cell contents" option is off.
- Set "Within:" to "Workbook".
Now do two different searches, one with the "
Look in:" option set to "Formulas", and again with it set to "Values" (but with all the above options as described).
As I said before, I'm reaching. But then at this point we're all scratching our heads unsure of what's going on, right?, so maybe I'm a genius and maybe I'm just wasting your time on another unlikely hypothesis, but either way it probably couldn't hoit.