If you copied a range doing

application.CutCopyMode = False

will empty the clipboard. Do this before the code that evokes the message

Or you can do

Application.DisplayAlerts = False
' code the evokes the message
Application.Displayalerts = True

--
Regards,
Tom Ogilvy


"funkymonkUK"
wrote in message
...

seems to be working except it keeps saying the is large amount of data
on the clip board. is there a way to stop that


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=517809