hi,
since i don't know how much or what your are trying to
paste i can only be general.
I have found that when useing the copy and paste commands
in a macro, if you do this a lot in one macro, excel will
freeze up. the cut and paste commands are even worst. i
don't know what causes it (it's a clipboard thing i think)
but over the years i have just avoided the situation and
learned to use other ways.
post back with more info about what you are trying to
paste.

-----Original Message-----
Hi all,

I'm trying to run a macro that copies some data from one
worksheet to 50 other worksheets using some specific
criterias. While the macro copies everything correctly
for
around half of the data it stops after that and gives me
the following error messages:

"Excel cannot complete this task with available
resources.
Choose less data or close other applications"

In the VBE it gives me:

"Run-time error 1004: Paste method of worksheet class has
failed".

Then when I close Excel after these messages:

"The picture is too large and will be truncated".

Has anyone experienced something like that before? I
don't
have any other applications open and I don't think that
this simple procedure should cause any problems with
Excel. It's really strange.

Any help is greatly appreciated!!!!

Manuel
.