Thanks Sandy

Yes I can still copy/paste from the formula bar but not multiple ranges.

If I rem out those lines in 2002 or 2003 it crashes looking for an object
variable.


Gord

On Mon, 12 Dec 2005 21:51:15 -0000, "Sandy Mann"
wrote:

Gord,

Oddly enough it the paste functionality remains for me in XL95 if I copy
from the formula bar. Also it seems to work just as well if I comment out
the IF and End If lines and just leave the:

OldCell.Interior.ColorIndex = xlColorIndexNone

By itself