I'm not sure why this is happening, but every other time I run this one specific macro, I get a "Run-time error '1004': Paste method of Worksheet class failed". I even tried running this macro, then running a different one, then running this again, but I still got the error every other time.
Every time I get the error, it highlights this line of code:
This is all of the code up to where I get the error:
Sub YesRegen() ' after user has hit Yes on the RegenerateRequest macro, this posts the new request to ' the log, generates the new file and attaches it to an email Application.Run "LogUnprotect" Range(Range("A" & ActiveCell.Row), Range("K" & ActiveCell.Row)).Copy 'Selection.Copy Sheets("Regenerate Request").Activate Application.Run "RegenFormUnprotect" Range("A40:K40").Select Range("A40").Activate Sheets("Regenerate Request").Paste
Can someone help me?? Thanks in advance!!!