ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Please Help!!!! (https://www.excelbanter.com/excel-programming/339502-please-help.html)

James_Newton[_2_]

Please Help!!!!
 

Hi I am writing a macro that copies and pastes alot of information from
1 spreadsheet to another but because of the clipboard on office xp I am
running out of memory to complete the task and the macro has to end.

I have tried using the command

Application.CutCopyMode = False

But this does not seem to work!

Any ideas people!


--
James_Newton
------------------------------------------------------------------------
James_Newton's Profile: http://www.excelforum.com/member.php...o&userid=18327
View this thread: http://www.excelforum.com/showthread...hreadid=465914


Gareth[_6_]

Please Help!!!!
 
I've replied to your previous post in this NG.

James_Newton wrote:
Hi I am writing a macro that copies and pastes alot of information from
1 spreadsheet to another but because of the clipboard on office xp I am
running out of memory to complete the task and the macro has to end.

I have tried using the command

Application.CutCopyMode = False

But this does not seem to work!

Any ideas people!




All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com