+ Reply to Thread
Results 1 to 6 of 6

Run-time error 1004 selecting range

  1. #1
    Registered User
    Join Date
    10-19-2014
    Location
    Nambour, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Run-time error 1004 selecting range

    Hi,

    I have a workbook with three worksheets and several existing procedures which are working OK. I am attempting to add a new procedure which needs to access one of the other worksheets, but I am getting a persistent run-time error 1004 "Method 'Range' of object '_Worksheet' failed" when trying to establish an active cell on the destination sheet.

    The code is copied from other procedures where it works successfully, and is as follows:

    'Look for Existing Chart
    Sheets("Chart List").Activate
    Range("CFirst").Select

    The range "CFirst" is defined with scope "Workbook", and error still occurs if I replace the range name with the cell reference "B2". Somewhere there must be a mirror not aligned correctly, but I have not been able to find it. Can anyone help please?

    Thanks

    Ray

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Run-time error 1004 selecting range

    Perhaps syntax like

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    10-19-2014
    Location
    Nambour, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Run-time error 1004 selecting range

    Error 1004 still there, now "Application-defined or object-defined error"

  4. #4
    Registered User
    Join Date
    10-19-2014
    Location
    Nambour, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Post Re: Run-time error 1004 selecting range

    Hi,

    I have found solution in a previous thread from 2013, need to add sheet name to Range Select statement as follows

    'Look for Existing Chart
    Sheets("Chart List").Activate
    Sheets("Chart List").Range("CFirst").Select

    This works OK now, but I don't understand why the previous instance worked without this addition.

    Thanks for reply.

    Ray

  5. #5
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Run-time error 1004 selecting range

    Is CFirst spelt correctly?
    Is the CFirst range on sheet Chart List?

  6. #6
    Registered User
    Join Date
    10-19-2014
    Location
    Nambour, Australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Run-time error 1004 selecting range

    Yes and Yes

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Run Time Error 1004 when selecting range on another sheet using a command button
    By randolphoralph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 07:43 AM
  2. [SOLVED] error 1004 Method 'Range' of object '_Worksheet' failed when selecting multiple ranges
    By Edejager in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 07:51 AM
  3. Error 1004 when selecting range from different sheet
    By normadsan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2013, 10:35 AM
  4. Error 1004 when selecting a range of cells
    By isrisian in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2011, 07:01 PM
  5. [SOLVED] Runtime Error 1004 on selecting range
    By MaltzMD in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-22-2005, 11:05 PM

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