+ Reply to Thread
Results 1 to 3 of 3

"We can't do that to a merged cell" error in non-merged cells

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    47

    "We can't do that to a merged cell" error in non-merged cells

    I'm encountering an error which reads "We can't do that to a merged cell" when I'm entering data into cells which are not merged. There are merged cells in the worksheet which reference the data cells, but what's unusual is that I'm not getting the error for every data cell. If I just select "OK" it enters the data fine and the linked formulas work properly, it's just kind of frustrating to have it pop up at seemingly random times.

    Has anyone else encountered this? Any idea as to what causes it and what might fix it?

    I've attached an example spreadsheet. The only thing the cells prompting the error have in common is that they're all for "Cmpd 2," which correspond to the bottoms of the merged cells in columns B through G. But not every "Cmpd 2" data cell does it. For instance in the example sheet, if you begin entering data into cell I2 and continue down the column, you'll first encounter the error at cell I9. From there down it will pop up every other cell. I can't tell what's different with cells I3, I5, and I7 that they don't produce the the error, and I don't know why "Cmpd 1," cells which correspond to the top of the merged cells in columns B through G, would not do it compared to the "Cmpd 2" cells that do it. I'm a bit perplexed.

    Sorry if that description is a bit confusing, but if you open the example spreadsheet and start entering data in the highlighted cells you'll see what I mean.

    Edit: Updated my Excel version
    Attached Files Attached Files
    Last edited by SaraLynne; 01-24-2020 at 12:12 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: "We can't do that to a merged cell" error in non-merged cells

    Administrative note

    Still using XL2003 as indicated in your profile?
    If not,perhaps update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to? Members tailor answers based on your Excel version.
    Thanks

  3. #3
    Registered User
    Join Date
    07-26-2013
    Location
    Massachusetts
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: "We can't do that to a merged cell" error in non-merged cells

    Sorry about that, I edited my post to say that but I can't find the option to edit it in my profile. Working on it now! It's been quite a while since I've been here!

+ 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. Merged cell error on copy/paste, but no merged cells
    By OmniBlue in forum Excel General
    Replies: 3
    Last Post: 07-15-2019, 02:15 PM
  2. [SOLVED] Merged cells autofit and "-"/"+" is first character
    By Linky in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-21-2013, 11:27 AM
  3. Auto Filling a Table with "Count" of merged cells
    By Kram222 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2012, 05:41 AM
  4. Replies: 3
    Last Post: 01-25-2011, 09:31 PM
  5. Double Click in Merged Cells to insert and delete an "X"
    By Ripperdan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2010, 10:07 AM
  6. [SOLVED] Merged cells cause "Runtime error 13 type mismatch" problem
    By Ralph Malph in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2006, 08:55 AM
  7. Replies: 3
    Last Post: 03-13-2006, 08:26 PM

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