Hi Howard,

Am Fri, 31 Jul 2015 09:07:00 -0700 (PDT) schrieb L. Howard:

This works quite well, and I will keep the other non array code also. I did have to change this If FERow = 50 Then to If FERow < 50 Then.

always glad to help.

But FERow is always <50 if it is not exactly 50.
If FERow is <=49 you can copy & paste. If FERow becomes 50 you get the
message box.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional