weird things happen sometimes
 

i was wondering if anyone else sees things like this:

1. i will have some code that formats a cell a certain color. i change the value
it works fine. i change to another color, it doesn't change. i even put a
breakpoint in the code so i could see if it skips it, it never even stopped
executing. i then put the breakpoint on the sub line, clicked the menu button,
code ran fine, didn't stop, and had the wrong color. changed the line of code
right before the color to change the value of the cell, then it changed the
color to the correct color.

2. with pagesetup code, i'll change the values of the margins, they'll change
once or twice, then no matter what value i set, the margins never change. move
that line of code to a different location under with pagesetup, and the margin
is changed.

3. did the same thing with a graphic header. wouldn't appear. moved it down a
few lines and it works.

it's as if all the code is stored in the cache and doesn't refresh the changes i
make in the vbe.

happens with forms designs, too.

does anyone else see these types of things?

--


Gary