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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Rupesh

    run-time error '1004'

    Rupesh, Nov 24, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    218
    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:
    146
    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:
    209
  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:
    1,380
    Frank Kabel
    Oct 16, 2004
  5. Guest

    Run Time Error '1004'

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

Share This Page