On Friday, February 22, 2013 10:55:36 AM UTC-8, GS wrote:
Howard expressed precisely :

Hi Garry and Claus,



I'm feeling like a real troublemake here.



I have tried all corrected versions the two of you offered. If I make

entries outside the B8:G25 range I get the familiar "Run-time error 91

Object... Block variable not set" Code line is yellow highlighted up to but

excluding Exit Sub.



On Error Resume Next seems to cure it, is it proper to do that?



(Maybe my Excel has the Flu, or maybe I do.)



I don't advise using an error escape. Claus' revision is the way to go,

and is what I should have posted if things around me at the time

weren't so hectic. (I was at the hospital receiving treAtment via IV

and kept getting interupted. No excuse, though! I apologize for all the

extra trouble!)



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

GS,

No need for appoligies, for sure. You have helped me often and I appreciate your patience and your good advice.

Got it working just fine.

I had it in the back of my mind that error escape should be used very sparingly, if at all.

A question on that very thing. Often when using the change event sub for some activity if I click, drag and highlight portions of the worksheet not included in the change event code, say to delete stuff I don't need I get an error about invalid entry or the such. On Error Resume Next seems to eliminat that, is that good practice??

Howard