Excel 2007 Unable to .pastespecial, Error 'object required'

CMSS

New Member
Joined
Jul 29, 2010
Messages
18
Also posted at http://www.excelforum.com/excel-pro...le-to-pastespecial-error-object-required.html

I am running a macro that copies data in a form into two different archives. If one cell in the form contains specific data, it copies all of the information to the second archive. When I run the macro, it brings up the error message

Run-time error '424':

Object required

and highlights
Code:
.Range("A1").End(xlDown).Offset(1, 0).PasteSpecial xlPasteValues

Here is th entire code for the macro:

Code:
    Application.DisplayAlerts = False
    Sheets("Data Collector").Unprotect Password:="c"
    Sheets("Session Archive").Unprotect Password:="c"
    Sheets("Data Collector").Range("A2:AC2").Copy
    Sheets("Session Archive").Select
    Sheets("Session Archive").Range("A1").End(xlDown).Offset(1, 0).PasteSpecial xlPasteValues
    Sheets("Calculator").Select
    If Range("H32") = "DOM" Then
        Workbooks.Open Filename:="C:\book2.xls"
        With Sheets("DOM Award Tracking").Select
        .Range("A1").End(xlDown).Offset(1, 0).PasteSpecial xlPasteValues
        .CutCopyMode = False
        .Close True
        End With
        Workbooks("C:\book1.xls).Activate
    End If
    Application.CutCopyMode = False
    Sheets("Session Archive").Protect Password:="c", _
        DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowSorting:=True
    Sheets("Calculator").Select
 
Last edited:

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,133,031
Messages
5,656,496
Members
418,307
Latest member
Labs05

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top