worksheets("Sheet1").Range("B9:F100").Copy _
Destination:=Worksheets("Sheet3").Range("M32")

--
Regards,
Tom Ogilvy

"Please help" wrote in message
...
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