HI,

I am trying to pate some data to a new workbook but it take the formulars as well

my macro calls up copy the add new workbook.

when i record the macro it does not record the paste part
at present i have activesheet paste
could you advise hoe to only copy the values into the added owrkbook

thank you

steve