+ Reply to Thread
Results 1 to 3 of 3

Cells-Formulas Move When Clicked On

Hybrid View

JDmacroman Cells-Formulas Move When... 07-21-2015, 09:30 PM
MarvinP Re: Cells-Formulas Move When... 07-21-2015, 09:41 PM
JDmacroman Re: Cells-Formulas Move When... 07-26-2015, 10:29 PM
  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

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,231

    Re: Cells-Formulas Move When Clicked On

    Hi Jay,

    This feels like the $K$4:$K4 is doing the magic. It starts at the top and counts down from the top. If you change something above the count will not be the same.

    See the example and change a value in column A and watch other values in column B change. I think that is what is happening but would need to see your workbook to see for sure.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

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

    Re: Cells-Formulas Move When Clicked On

    Hi Marvin,
    I appreciate your post and I thought it might indeed have something to do with the array formula, plus something was making the sheet extremely slow to load and to save. So, I replaced the array formula with a pivot table. Now, there are no delays and it loads/saves without any such problems.

    Thanks again for your input.
    Jay

+ 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. [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