Yes i manipulate the file name because the file name has a date in it that changes for each days date for each file name. And as far as using constant or variables i don't know how but that sounds like a plausible solution. As for what the code does it formats certain data, it enters a date, and it copies. I'm not interested in shortening it unless you feel you want to but the part that i am trying to achieve is avoid having to open the macro hold button control while pressing f using the find replace the date 1 date 2 date 3 date 4 date 5 date 6 into the actual dates which is the actual file name. If i could type the dates in as a constant or variable at the top that would be great but how do you do that?