VBA: Copy Sheet to Another Sheet With Criteria

[muhammad susanto]

hi all..
how to make code copy to another sheet with criteria:
- paste special value,
- keep formatting
- keep format number decimal
- remove formula
i have trying this code but not working

Sub coy()
Sheets("master").Copy.PasteSpecial Paste:=xlPasteValues
End Sub

thanks in advance

m.susanto

 

[Joe4]

I would recommed doing this in two steps.
First just doing a copy, to copy the entire sheet "as-is". That should keep all formatting.
Then, you can do a Copy --> Paste Special --> Values of the new sheet over itself to turn the formulas into hard-coded values.

 

[muhammad susanto]

hi Joe, thanks you but i need that vba code.