EXCEL VBA - Run-time Error 1004

Discussion in 'Microsoft Excel Worksheet Functions' started by sakieboy, Jan 29, 2004.

  1. sakieboy

    sakieboy Guest

    run-time error 1004 - Copy method of sheets class failed.

    Sheets("All_Reg_Data").Select
    Dim i_WHY_AM_I_5 As Integer
    i_WHY_AM_I_5 = 5
    Range(Cells(1, i_WHY_AM_I_5), Cells(1,
    i_TotalNumberOfColumns - 1)).Select
    Selection.Copy
    Sheets("Reg_Data").Select
    Cells(1, i_WHY_AM_I_5).Select
    ActiveSheet.Paste
    Sheets(Array("Reg_Data", "Reg")).Select
    Sheets("Reg").Activate
    Sheets(Array("Reg_Data", "Reg")).Copy

    I received the error on the final line.

    The table consists of 6 sheets.

    The Reg_data is a table of Data, the Reg is a graph. Not
    sure if this makes a difference.



    Thanks for your help
     
    sakieboy, Jan 29, 2004
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Rupesh

    run-time error '1004'

    Rupesh, Nov 24, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    401
    Dave Peterson
    Nov 24, 2003
  2. henry marden

    Run-time error 1004

    henry marden, Feb 3, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    313
    henry marden
    Feb 3, 2004
  3. Will

    error macro run-time 1004

    Will, Feb 9, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    449
  4. Guest

    Run-time error '1004' Method 'Save' of object '_Workbook' failed

    Guest, Oct 15, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    3,187
    Frank Kabel
    Oct 16, 2004
  5. Guest

    Run Time Error '1004'

    Guest, Sep 23, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    273
    Chip Pearson
    Sep 23, 2005
  6. Guest

    Run Time Error 1004

    Guest, Jun 27, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    202
    Roger Govier
    Jun 27, 2007
  7. aeddave

    Run time error '1004'

    aeddave, Jan 30, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    180
    Dave Peterson
    Jan 30, 2008
  8. Bishop

    Run-time error: '1004'

    Bishop, May 21, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    247
    Bishop
    May 21, 2009
Loading...