Hi Sabre -

Glad to hear working with Norman's code set your procedure back on track.

While trouble-shooting your problem, I noticed that your procedure skips the
testing of the column C cell after it finds a blank and deletes the row. If
this is what you intended, disregard this post.

However, if you want to test every row for the presence of "I", consider
adding the following line:

RowCounter = RowCounter - 1

After:

BlankCounter = BlankCounter + 1

--
Jay


"Sabre" wrote:

Just tried using the bit of code provided by Norman Jones for debugging and
it set to True and False as it should. Removed the debugging code and it all
started working perfectly!

Weird. But thanks Norman all the same!



"Sabre" wrote:

I've got a dead simple bit of code where I switch screenupdating on, run a
small section of code (basically runs a routine that puts up a percentage of
progress so the user doesn't stare at a mental screen but still gets some
feedback) and then I try to switch the updating off again so that the code
can carry on.

Problem is that the updating isn't switching off, if I go through the code
line by line it gets to the '=false' line and it executes without any errors
but in the watchwindow screenupdating is still showing as being '=True'.

Never come across this before, any suggestions?