Macro to Copy and paste special values only

[frhj]

I want to be able to create a macro to copy and paste special values only from a D10 to D20 in a worksheet named "Invoice" to a sheet named "reports" in the next blank column. Any help on this matter would be appreciated.


thanks alot

 

[sdsurzh]

Hi,


Insert a module and paste the below code


Sub copypaste()

Worksheets("invoice").Select

Range("d10:d20").Select

Selection.Copy

Worksheets("reports").Select

Range("a1").Select

Selection.PasteSpecial xlPasteValues

Application.CutCopyMode = False

End Sub


Thanks,

Suresh Kumar S