Wow, thanks for the help!! I tried changing Range, but it never occurred to me to just change it to object.

I can't thank you enough for your help

I changed my code as suggested but it still will not work. When the program executes the next line it gives me the error "application defined or object defined error". when i open the Immediate window and test for the FormulaPasteArea value i get the message "object variable with block variable not set". I don't know what to do to correct this. Could someone help me please?