Hi
try something like
Worksheets("Sheet1").Range("C1:C5").Copy
ActiveSheet.Paste Destination:=Worksheets("Sheet2").Range("D1:D5")


--
Regards
Frank Kabel
Frankfurt, Germany

Please help wrote:
How can I copy a range of cell from sheet 1 and copy them to a
different range of cells in Sheet2 using VBA code? If you have any
suggestions, it would be greatly appreciated