copy and paste from one sheet to another


Posted by Jim on December 27, 2001 10:37 AM

Hi group,

This should be so simple, but it's kicking mine.

All i'm trying to do is on sheet 1, select a range
Range("B2:J2") and have it copy and paste to sheet 2
Range("B5:J5") WITHOUT leaving Sheet 1. So by using
the recorder you have to leave Sheet 1 to paste in
sheet 2. And when i use Application.CutCopyMode = False
it doesn't copy anything. What am i not seeing???

Thanks, Jim

Posted by Gary Bailey on December 27, 2001 10:43 AM

You don't need to select sheet2 to cut and paste. Try

Sheets("Sheet1").Range("B2:J2").Copy Sheets("Sheet2").Range("B5:J5")

Gary



Posted by Jim on December 27, 2001 10:53 AM

Thanks Gary, after i pulled my head out,it works fine