The yellowed line is where VBA has a problem in continuing to execute the
code, it nay not be the line where the problem is. For instance, there is
nothing intrinsically wrong with this code

Range("A1").Resize(7,myVar).Select

but if myVar contains the value 0 will fail. That line will yellow, but the
problem is where nyVar is set, or not.

Post your code, and explain what it is doing, and we'll take a look.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ed" wrote in message
...


"JW" wrote:

Hi Ed,
It has been my experience that the proble is always in the line that is
yellowed.

"Ed" wrote:

In a macro procedure that runs over and over again automatically, then
stops
because of a problem. Then you look at the procedure to debug it and
find
the line the is marked in yellow. Is the problem always in that
yellowed
line or could it be in the next line or in the line preceding?
Thankyou,
Ed
Hi JW
Thanks for the information.
I guess I always thought the problem was always in the yellowed line.
My question was prompted by getting an END IF line with the yellow mark.
Then I couldn't figure out what could be wrong with that line.
It was spelled correctly and everything.
Got any comments on that?
Ed