macro error 1004 paste method of worksheet failed

[mrxwanttobe]

Hello all. I have a worksheet that I need to make changes to daily so I wanted to record a macro. I open the worksheet, delete about 5 columns, then insert 3 columns B,C,and D. I put formulas in these columns and after completed I copy and paste special and pick values. So far all is good. I save the workbook under another name and all is fine. The problem is if I open the origonal file and run my macro it is fine up until it creates my B,C and D and then I get the above error. all three columns are blank. I don't understand as I save the three columns as values. Whys does it work fine the first time I run the macro but never again.
Thanks in advance

 

[offthelip]

I suggest you post your current code so that that we have a chance of diagnosing the problem.

 

[Marc L]

Whys does it work fine the first time I run the macro but never again.

Hello, that's just a bad code obviously ! Check the codeline where the error raises …​