Clear Clip Board Memory
 

Hi I am writing a macro that copies and pastes alot of information fro
1 spreadsheet to another but because of the clipboard on office xp I a
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!

Thank you in adavnce

--
James_Newto
-----------------------------------------------------------------------
James_Newton's Profile: http://www.excelforum.com/member.php...fo&userid=1832
View this thread: http://www.excelforum.com/showthread.php?threadid=46589

Clear Clip Board Memory
 

Two thoughts:

a) Are you sure you need to use the clipboard. Most of the time it's
easier simply to write directly to a range rather than copy one range to
another.

e.g.
Range(ActiveWorkbook.Sheets(2).Cells(1, 1), _
ActiveWorkbook.Sheets(2).Cells(100, 20)).Value = _
Range(ActiveWorkbook.Sheets(1).Cells(1, 1), _
ActiveWorkbook.Sheets(1).Cells(100, 20)).Value

b) Have you tried:
Sub EmptyClipboard()
Dim myData As DataObject
Set myData = New DataObject
myData.SetText ""
myData.PutInClipboard
Set myData = Nothing
End Sub


HTH,
Gareth


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!

Thank you in adavnce!