I have a macro that copies one line (a named range) and pastes the format from this line to 1000 lines (also a neamed range). It worked no problem in Excel 2000 and 2003, but is giving a "run time error 1004 " "PasteSpecial Method of Range class failed". When I do this same process manually, I...