Hello again, Paul_Hossler
don't worry about changing the colors, I'll change them to whatever I want.
As for the macro and accounts:
Yes, they are correct and there are no two opinions about it.
Please look at post number 10.
Either I'm oligophrenic or I have some kind of problem. I'm using office 2007 (my personal preference, I can use another but I don't want to).
In post 10 I mentioned, now I will write again, I have no idea why when I clicked somewhere in the table (inadvertently/arbitrarily selected cell) and pressed the button to activate the macro it colors the cells wrongly (I will show a picture, how it moves and calculates the wrong coloring ) because it takes another cell for comparison.
However, when I clicked exactly in the given cell, the calculation for that same row is correct.
This is the first time this has happened to me, it goes and selects CF chaotic cells, but not what it is told to do with that CF.
Am I misunderstanding it or am I having some problem Paul_Hossler?
The macro is perfect and I'm very grateful, that's the only thing that bothers me, why does it shuffle the lines, it's kind of crazy to me.
2023-03-14_071011.jpg
2023-03-14_074535.jpg
P.S - I think my problem comes from the fact that I am using office 2007.I tried on newer versions and everything works fine there.
Is there an option to tweak it to work on my version?
I guess there are some differences in the writing of the macro itself, I can't think of anything else as a problem.
Thanks in advance!
Reply With Quote
