Mattman,
The first code pastes VALUES ONLY, so why do you to paste them again?
If you are calling the first macro from the second macro, the first amro has to complete running until the sub ends, unless otherwise, you instructed to stop somewhere.