Pasteing from Clipboard Runtime error 1004: Paste method of worksheet class failed

Hey all!

I have a weird issue. I have had this macro working for the past 7 months with no issue. I wanted to recreate the the form and the only difference i see is the original copy selection.

Old form was a rich text file that i copied onto the clipboard and pasted special into excel.
New form is already in excel and i copy the whole sheet to the clipboard so i can paste into my macro enabled workbook.Below find the section on my working original code.

Please Login or Register  to view this content.

I have tried to copy paste this code into the new macro book to work with a few tweaks. I got rid of the fixed width because its already in excel and just used the following with no success.

Please Login or Register  to view this content.

It always errors out on the ActiveSheet.Paste line. I have made sure to not copy too much (ie. every row/column in the worksheet) but it still errors out. If i do a manual copy paste and run the next macro everything works fine.

Any help would be greatly appreciated!!

Thanks,
Ozman