Hi,

Windows XP
Office 2003

I have been trying to write a macro that just copy a lot of informatio
from one sheet and then paste it into another as value, and the macr
has to do that several times. The problem is that when try to do it fo
the fourth time, Excel gives a message error that indicates th
application ran out of resources or something like that...in othe
words y put too much information in the clipboard y the syste
collapse. So I tried to clear the clipboard every time I paste the inf
and I tried to use the following instruction:

Clipboard.Clear and the Excel gave an "424" error...so VB it wa
missing an object, so I tried the following
My.Computer.Clipboard.Clear() and then Excel gave me an error that i
was expecting a "=".

I have searched in all kind of forums and everybody seems to us
Clipboard.Clear without a prob into thier codes, why I am having al
this trouble?, it is not my computer, because I have tried this a
least in three diffferent computers, so I am doing something wrong. Ca
you help me out, please!!!!!!!!!!!!!!

Regards

Andres Navarret

--
andres.navarre
-----------------------------------------------------------------------
andres.navarret's Profile: http://www.officehelp.in/member.php?userid=458
View this thread: http://www.officehelp.in/showthread.php?t=122023

Posted from - http://www.officehelp.i