Jiptastic

romperstomper's code will work, it is copying from the active sheet to 'Pasted Zip Codes'.