PC Review

Thread Tools Rate Thread

EXCEL VBA - Run-time Error 1004

Posts: n/a
      29th Jan 2004
run-time error 1004 - Copy method of sheets class failed.

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
Cells(1, i_WHY_AM_I_5).Select
Sheets(Array("Reg_Data", "Reg")).Select
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

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
run time error 1004 general odbc error excel 2003 vba =?Utf-8?B?TWVudG9z?= Microsoft Excel Programming 5 24th Jan 2011 03:56 PM
Excel VBA error 1004: General ODBC Error rhysgowat Windows Vista 0 24th Jul 2010 02:20 PM
Error 1004 opening workbook 1004 WembleyBear Microsoft Excel Programming 2 30th Nov 2009 02:33 PM
Excel VBA - Runtime Error "1004" General ODBC Error SKS Microsoft Excel New Users 2 23rd Jun 2004 07:54 PM
runtime error 1004 when opening excel file via VBA in a browser Ken Hunter Microsoft Excel Programming 2 31st Jul 2003 03:33 PM




All times are GMT +1. The time now is 03:39 PM.