Help! My macro can't seem to paste values

[maytey]

Hi,

I need help... have downloaded a macro from one of the users here.. but i can't seem to paste value my worksheets.

There was a prompt on whether i want to save the copy on the clipboard. And the macro just stops there. I had no problem while testing with smaller files. This only happened when i was trying to paste worksheets from macro workbooks which are has pretty large filesize.

Here's the macro attached.. Appreciate if someone can help urgently..

Thanks in advance!

[mdmackillop]

Can you step through the code and identify the problem line? If possible can you paste a sample workbook containing the problem sheet?

[maytey]

Hi, Here's my file which i run..
Can you help to go thru? Apparently it stops pasting when the message.. "There is a large amount of information on clipboard. Do you wan to save?"

Thanks for your help!!Attachment 9985