Maddening Dilemma - Compare each cell within column a to each cell
I've just been checking back on earlier posts. My first macro was
comparing exact values, so you could re-instate that line if you wish.
A few days later I gave you a modification to look only at the tenths.
If you now want to look at the hundredths, then you should modify that
line in the macro and change 10 to 100 (four times in the line).
I also noticed that your posting on October 9th said that you may have
a one-to-three way cancelling, which contradicts what you said earlier
- just trying to get a more complete understanding. <bg
Pete
On Nov 12, 7:17 pm, wrote:
Pete,
Also, part of it may be that i requested the macro just check till the
TENTHS place (first after the decimal), when in fact, it may be wiser
to check to the hundreth's place, just to be safe.
Can you modify the code to do that? Or how can I?
Link to sample will be up tonight.
Thanks Pete.
|