Thank you for your clever response. I see that the macro you gave me works
well. However I still have a problem.. The file being created by the software
is an excel file, but I can't seem to make the software input the macro you
gave me. So the file is created and then in order for me to use your macro I
would have to put in afterwards which doesn't suit. I don't know much about
macro's so maybe I'm missing something????



"ASU" wrote:

How can I copy and paste formulas, using vb codes, when creating a new
spreadsheet.
--
ASU