Look up PasteSpecial in VBA help. There is a formulas option in the type
argument.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ojchippy" <ojchippy@discussions.microsoft.com> wrote in message
news:BDB9D195-999F-4C06-8544-E1CB87BB67D4@microsoft.com...
> I am trying to copy data from a table that has formulas assigned to it so
> that when I enter new data in the table the formulas still work. When I
copy
> the data all I want to copy is the raw data, No formats, cell names etc.
Also
> I was hope to do all of this by a macro but can't get it to work
correctly.
> Please help