Results 1 to 3 of 3

Cells-Formulas Move When Clicked On

Threaded View

  1. #1
    Registered User
    Join Date
    07-24-2011
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010 & 2013
    Posts
    14

    Question Cells-Formulas Move When Clicked On

    I have a question regarding an anomaly or something that is happening in Excel, but not always.

    I have a spreadsheet with a column (K) of array formulas
    =IF(INDEX(CCList,MATCH(0,COUNTIF($K$4:$K4,CCList),0))=0,"",INDEX(CCList,MATCH(0,COUNTIF($K$4:$K4,CCList),0)))
    and in the column (L) to it's right, I have a column of SUMIF formulas
    =IF($K4="","",SUMIF(CCRange,$K4,AMTRange))

    So, sometimes when I click on cell L4 or any cell, the cells in column K move, so the SUMIF formulas move... but then other times, they do nothing.
    Why is that happening and how can I stop it from occurring? Is there something wrong with my formulas to make this happen? I have no code designated for any change events. Note: I added a short video clip, and attached it in a zip file.

    Thanks for your time and attention to this issue.
    Jay
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Make button move when clicked
    By ed67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-09-2015, 09:02 AM
  2. Enter functions in cells that are fired by events when cells are clicked
    By GCW esq in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2014, 05:05 AM
  3. [SOLVED] making a cell in a worksheet (when clicked on) move you to a different worksheet
    By gwa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-06-2013, 06:44 PM
  4. [SOLVED] Load web image when cell holding URL is clicked/double-clicked
    By jchamber00 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2013, 09:13 PM
  5. VBA to automatically move command button to another cell after being clicked on
    By vaznlyfe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2012, 11:29 AM
  6. Macro to move data from sheet1 to sheet2 when clicked
    By excel77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2009, 01:18 PM
  7. Change cell value when right-clicked/double-clicked
    By grime in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2005, 09:05 AM

Tags for this Thread

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