Quote:
Originally Posted by beaner
So the loop is defaulting $. Pretty sure i am right...
|
No, my friend, you are wrong on this one. You are missing what I am saying. Look at the image. All cell formatting starts disappearing near where I have the arrow pointing to the formatting is disappearing. The borders disappear, the formatting (bolding, number format, all) disappears.
It later comes back.
There is no default format. It is a programming object, you have to tell it what to do in a program. I am telling it to format this way, that way, the other way. At a certain point, it just stops listening.
I will do another test file and show you what it does with just borders but no actual number formatting. Eventually the borders just disappear. That will take a few minutes to create.
Thanks again.