Thanks heaps.. Worked a treat.

I knew it was something simple..

Dale


"Jan Karel Pieterse" wrote in message
...
Hi Dale,

I am then asked if i'd like to keep the data on
the clip board for use else where.

How do I stop this message or reply 'NO' in VBA?


Add this line after the paste is done:

Application.CutCopyMode=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com