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