Copy And Paste To New Workbook

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

You will have to be more specific

Will you be creating the new workbook as part of the macro?
do you just wish to copy data and not formulas?
Is it a full sheet or just a specific range?

Why not create it as a keystroke macro, it is fairly straightforward, perhaps something like the following, select range, (or sheet) copy, add new workbook, paste special values, escape. then stop the macro



Sub Macro1()
Range("A1:D6").Select
Selection.Copy
Workbooks.Add
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub


Regards

Dav

Thanks Dav

Sorry for not explaning well but it was the last 3 lines i needed and it works a treat

thanks

steve

Hi Dave

This code helped me a lot in making my MIS.
But a slight issue.
The formating is not copied.
only either the values or the formats can be done at a time.
request you to please help with the code whith which both the cell formating and values can be copied excluding the formulas.

{i am a big zero with coding, but do debugging well, the cut copy paste methode....}

Thank you...

Please Login or Register  to view this content.