On Friday, July 31, 2015 at 9:13:22 AM UTC-7, Claus Busch wrote:
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.

Well, that make sense for sure. I'll revert it back to what you had.

Thanks.

Howard