Romperstomper, I am pasting from the activesheet to another, so this solution doesn't work. Do you really need that many periods before cells and before Range?