Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data on clipboard message...
Hi all,
I have a simple macro that copies a range of cells and pastes the copied cells into a different spreadsheet. In doing this I open the file I wish to copy from.. once copied and pasted, the macro closes the file. 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? Help would we so much apreaciated. Regards, Dale |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data on clipboard 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data on clipboard message...
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Message: 'Cannot empty clipboard' | Excel Discussion (Misc queries) | |||
Message: Cannot empty clipboard | Excel Discussion (Misc queries) | |||
Clipboard Message | Excel Programming | |||
By-passing clipboard message | Excel Programming | |||
How to avoid "large data on clipboard" message? | Excel Programming |