View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Copy and Paste Problems

It don't like the Paste. Try this and watch the word wrap on the newsreader.
There should be only two lines.

Sheets("Work Schedule").Range("A1:X5").COPY Sheets("Overtime").Range("A1:X5")
Sheets("Work Schedule").Range("D6:X35").COPY
Sheets("Overtime").Range("D15:X44")

"Anna" wrote:

I want to copy and paste the following cells:

Copy cells A1:x5 from the Work Schedule tab and paste to cells A1:X5 on the
Overtime tab

Copy cells D6:D35 from the Work Schedule tab and paste to the cells D15:X44
on the Overtime tab

I created a button with the following code but get a run-time error 438

Sheets("Work Schedule").Range("A1:X5").COPY
Sheets("Overtime").Range("a1:X5").Paste
Sheets("Work Schedule").Range("D6:X35").COPY
Sheets("Overtime").Range("D15:x44").Paste