Results 1 to 7 of 7

Run-time Error '1004' Activate Method of Range class failed

Threaded View

gujugolf Run-time Error '1004'... 10-13-2012, 11:35 AM
zbor Re: Run-time Error '1004'... 10-13-2012, 11:43 AM
gujugolf Re: Run-time Error '1004'... 10-13-2012, 11:50 AM
Bishonen Re: Run-time Error '1004'... 10-13-2012, 11:43 AM
Bishonen Re: Run-time Error '1004'... 10-13-2012, 11:53 AM
gujugolf Re: Run-time Error '1004'... 10-13-2012, 12:01 PM
jeffreybrown Re: Run-time Error '1004'... 10-13-2012, 12:08 PM
  1. #1
    Registered User
    Join Date
    10-13-2012
    Location
    Carrollton, TX
    MS-Off Ver
    Excel 2007
    Posts
    30

    Run-time Error '1004' Activate Method of Range class failed

    I am new to VBA and macros. I am trying to use a button to copy data from one sheet to another. When stepping through the code, I do not have any problems. When I use the button, it gives me the error. Any help is appreciated, thanks in advance.

    Sub SendtoTracker_Click()
    Dim FirstBlankCell As Range
    Set FirstBlankCell = Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    
    
    Application.Goto Worksheets("IB-OB").Range("a2")
    Range("a4:g4").Select
    Selection.Copy
    Sheets("Sheet3").Select
    FirstBlankCell.Activate
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    
    
    On Error GoTo 0
        Set FirstBlankCell = Nothing
        End Sub
    Last edited by gujugolf; 10-13-2012 at 11:49 AM. Reason: added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1