You want to copy a range of cell and paste it to another sheet.
you have two sheets named as sourceSheet and destinationSheet
Use the following code:
Sheets(”sourceSheet”).select
Range(”A1:F1″).select
Selection.Copy
Sheets(”destinationSheet”).select
Activesheet.Paste
No comments:
Post a Comment