Run-time error '1004' Method 'Sheets' of object'_Global' failed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to excel and don't really know what I'm doing. When the below macro is executed (through changing a combo box) the macro appears to run fine but when I close the workbook the above Run-time error message dialog box comes up, can anyone help?

Sheets("dec").Range("A1:CO111").Cop
Sheets("ROTA VIEW").Selec
Range("B4").Selec
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:=
False, Transpose:=Fals
Range("B3").Selec

Thanks
 
Richard,

Add the line
Application.CutCopyMode = false
before you close the workbook.

HTH
Henry

Richard B said:
I'm new to excel and don't really know what I'm doing. When the below
Click to expand...
macro is executed (through changing a combo box) the macro appears to run
fine but when I close the workbook the above Run-time error message dialog
box comes up, can anyone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error 1004 paste method of worksheet class failed 3
Macro to run on hidden sheet 4
Run-time error "1004" Select method of range class failed 3
Macro - File Save As 2
Macro Error 1004 3
Macro run time error 1004 1
End Down a second time 1
Runtime 1004 error -- insert method of range class failed. 1

Back
Top