Copy And Paste To New Workbook

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...

Selection.PasteSpecial Paste:=xlValues And Formats, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False