+ Reply to Thread
Results 1 to 3 of 3

VB error:"1004" Calculate method of range class failed when selecting a cell with Array

  1. #1
    Registered User
    Join Date
    11-29-2013
    Location
    Pattaya, Thailand
    MS-Off Ver
    Excel 2013
    Posts
    71

    VB error:"1004" Calculate method of range class failed when selecting a cell with Array

    I use a little code in accordance with a CF rule that highlights an entire row no matter what column I'm in.
    Please Login or Register  to view this content.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Normally it works like a charm, but I just added a Transpose {array} formula to a couple of cells and now I get this error every time I click on a cell with that formula. Nothing breaks, and I can just click end to continue, but I don't want to explain people to just not click those cells. Googling this error gives me results that go back 7 or 8 years and have nothing to do with the version of excel that I'm using (2013)
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Any way to fix this, or should I just park the transposed data in a hidden helper column and reference the visible ones to there?
    Last edited by Leith Ross; 12-25-2013 at 02:28 PM. Reason: Added Code Tags

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: VB error:"1004" Calculate method of range class failed when selecting a cell with Arra

    How about trying a sheet calculate

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-29-2013
    Location
    Pattaya, Thailand
    MS-Off Ver
    Excel 2013
    Posts
    71

    Re: VB error:"1004" Calculate method of range class failed when selecting a cell with Arra

    Thanks Bob, that did the trick.
    When I checked other sheets to update them as well, it turned out they were already using the very same code.

    Maybe one day I'll understand, but for now I'm happy enough with the solution alone.

+ 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" paste method of worksheet class failed
    By Ghostturd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2013, 10:21 PM
  2. Runtime Error 1004 "Active method of range class failed".
    By new2excel2012 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 07:55 AM
  3. Excel VBA Runtime error 1004 "Select method of Range class failed"
    By jeskit in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2012, 10:16 AM
  4. Runtime Error "1004" Autofill Method of range class failed
    By DonKarlos in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-15-2009, 07:44 PM
  5. [SOLVED] [SOLVED] Error 1004: Calculate Method of Range Class Failed
    By Dan Winterton in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2005, 06: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