Hi Howard,

Am Tue, 21 Apr 2015 05:15:30 -0700 (PDT) schrieb L. Howard:

When Sub Col_A() moves a short list of text or numbers up a row at a time, when the top entry of the list gets to A1, I need one of the event codes to fire so I can process the A1 entry.

Neither of these event codes work unless I manually enter something in A1, where the Change event works, or do a simple calculation in a cell =1+1 enter, then the Calculate event code works.

Worksheet_Change does not work with copy & paste
Worksheet_Calculate does not work if there are no cells to calculate on
the sheet.
Write in a empty cell =TODAY() and Worksheet_Calculate works.


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