Run Time Error '1004' PasteSpecial method of Range class failed.

[TDPorter]

So it worked perfectly!... Until I tried to use it for some additional cells that I wanted to copy from the temp file to the active worksheet "overview". What am I doing wrong? The error I recieved is as follows:

Run Time Error '1004' PasteSpecial method of Range class failed.

See code below:

Dim wbS As Workbook
Dim ws As Worksheet, wsA As Worksheet
Dim myFile As String
Set wsA = ThisWorkbook.Sheets("overview")
myFile = Application.GetOpenFilename("Excel Files (*.xls), *.xls")
Set wbS = Workbooks.Open(myFile, False, True)
Set ws = wbS.Sheets("DAILY TALLY")
ws.Range("D31:S31").Copy
wsA.Range("O40").PasteSpecial Paste:=xlPasteValues, Transpose:=True
ws.Range("U31:W31").Copy
wsA.Range("J48").PasteSpecial Paste:=x1PasteValues, Transpose:=True

 

[Norie]

You've actually got x1PasteValues for the 2nd PasteSpecial.

 

[TDPorter]

It's only that way in the thread, my macro shows the correct "xlPasteValues", no "1"..... Any help?

 

[Norie]

That's the only thing that appears wrong.

Is the destination workshet protected at all?

Does it have merged cells?

 

[TDPorter]

Nope, not protected and not copying or pasting from any merged cells.... It works fine if I remove the last two lines. Its only when I try to grab the second set of cells it doesn't like it anymore.

 

[Norie]

Do you have Option Explicit at the top of the code?

 

[TDPorter]

Not that I can tell, I'm not sure what that is........ Sorry, still learning, I'm a novice or even beginner in some eyes.

 

[Norie]

Goto the top of the module and just type Option Explicit.

Then Debug>Compile VBAProject.

Does that highlight, warn about any problems?

 

[TDPorter]

That worked! What exactly does "Option Explicit" do when put in the code? Besides make it work....

 

[Norie]

Well, it shouldn't actually do anything.

Using Option Explicit forces you to declare all variables, which is a good thing.

It helps you eliminate typos for example.

Anyway, after you added it what happened the next time you ran the code?