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