Well i thought that would work but it didnt copy over to sheet2. Any thoughts? I changed code to what you had listed in red.