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 |
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 |
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 |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com