On Friday, July 12, 2013 6:32:07 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Fri, 12 Jul 2013 06:02:36 -0700 (PDT) schrieb Howard:



Am I misunderstanding the line below about Target.Count?

I can still select more than one cell in the target range and the activecell of that selection will take an input. I guess its really is no big deal, just thought that would eliminate multiple selections.



yes, but you only change the active cell and that is only one cell. But

you will get an error message when you select more cells and try to

delete them. Or if you select more than one cell and make an input in

the active cell and then press CTRL+Shift+Enter all cells will be filled

but the makro doesn't start because target.count 1





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Okay, got it.

Thanks again.

Regards,
Howard