+ Reply to Thread
Results 1 to 10 of 10

Adding fill to cell always gives marching ants border, too

  1. #1
    Registered User
    Join Date
    09-24-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Adding fill to cell always gives marching ants border, too

    Windows 10, Office 365 Personal, both with all updates.

    The subject line pretty much says it all. When a friend selects a cell, then the 'paint bucket' icon on the ribbon to add a fill color, no matter what color he chooses, the cell is filled with the selected color, BUT he also gets a 'marching ants' border, which he doesn't want. That border will disappear if he presses Esc. IOW, it's behaving as though adding a fill also copies the cells. This is an XLSX file, i.e. no macros.

    Is this a new bug?

    I found info in another thread suggesting it's a keyboard problem. He's tried a different keyboard. That doesn't fix it.

    A Quick Repair of Office doesn't fix it.

    He's sent me a copy of the workbook. I can't replicate the problem.
    Last edited by Myrna Larson; 03-14-2018 at 03:38 PM.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,008

    Re: Adding fill to cell always gives marching ants border, too

    .
    IOW, it's behaving as though adding a fill also copies the cells.
    In essense ( or perhaps literally ) the process does copy the cell ... at least the formatting. Then 'pastes' the formatting into the new cells where the paintbrush has been dragged across.

    As far as the remaining 'marching ants' .... it should disappear once the mouse button is lifted. I'm using Excel 2007 and the marching ants disappear here as they do for you. Do the 'ants' remain
    for any workbook he works on .. or just the one he forwarded to you ? If it's only the one workbook ... it would appear there is something possibly corrupted therein.

  3. #3
    Registered User
    Join Date
    09-24-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding fill to cell always gives marching ants border, too

    Thanks much for your thoughts.

    The 'ants' remain until he hits ESC. It's all workbooks, not just this one, including a newly created, empty workbook in which he's just clicked on a cell, then clicked the Fill button. Also, this behavior only started recently.

    I think there's corruption in Excel (on his machine). He's doing an on-line repair. I'm hoping that will fix it.

    From what I've found on-line, there's no way for a user to create a 'marching ants' border -- only Excel can do it, because those 'ants' are reserved as an indicator that the copied cell contents are still on the clipboard, to enable pasting multiple times. I did find VBA code that simulated thie 'marching ants' by using a dashed line as the border, and repeatedly changing the dash pattern. Don't remember how they managed to continue that for the entire time the workbook was open, but it sounds to me like it would cause a real slowdown.

    PS: I was formerly a MS MVP for Excel, from 1994 - 2004, but haven't had the time to continue that.
    Last edited by Myrna Larson; 03-14-2018 at 04:28 PM.

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,008

    Re: Adding fill to cell always gives marching ants border, too

    .
    I agree, it sounds like some type corruption. Wish I had more to offer.

  5. #5
    Registered User
    Join Date
    09-24-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding fill to cell always gives marching ants border, too

    Thanks again for your thoughts!

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adding fill to cell always gives marching ants border, too

    Who doesn't know the name Myrna Larson?

    What if he opens Excel in Safe mode?
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Registered User
    Join Date
    09-24-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding fill to cell always gives marching ants border, too

    Thanks for that suggestion.

    Are you an 'old friend' from MVP days? With 38,742 posts I'd bet YES!

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adding fill to cell always gives marching ants border, too

    No, MVP 2011-2017.

    But I've seen your permutations and combinations code posted maybe 38,742 times
    Last edited by shg; 03-16-2018 at 11:51 AM.

  9. #9
    Registered User
    Join Date
    09-24-2012
    Location
    Wisconsin, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Adding fill to cell always gives marching ants border, too

    Yes, that whole thread appeared in (AIR) 2005, when the code wouldn't run because things had changed in Excel since 2000 or 2001.

    The code had a constraint, that the results had to fit on a single worksheet, so it checked for that, using the Count property, which returns a long integer. In the interim, MS had increased the number of cells on a worksheet to a number that exceeded the maximum for a long integer. So you couldn't use Sheet.Cells.Count any more.

    The guy started the thread because it was aborting due to an error. He found the problem, but he didn't know enough VBA, so he 'fixed' it by commenting out the error check.

    Are you the fellow who provided the correct fix, i.e. If N > .Cells.CountLarge Then.... ?

    If so, thanks! I only discovered the thread a year or so ago, 15+ years too late!!! Not very good 'customer service'.
    Last edited by Myrna Larson; 03-14-2018 at 08:06 PM.

  10. #10
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Adding fill to cell always gives marching ants border, too

    Are you the fellow who provided the correct fix, i.e. If N > .Cells.CountLarge Then.... ?
    If it was me, Myrna, it's way lost to the mists of time.

+ 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. Get Marching Ants Range
    By kev_ in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 12-27-2017, 12:29 PM
  2. [SOLVED] Remove 'marching ants' from copied cell
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2017, 12:26 AM
  3. Copy and Paste no longer showing the "marching ants."
    By Neener in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-01-2014, 07:08 AM
  4. Remove marching ants after notepad macro opens notepad
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-07-2014, 09:47 PM
  5. Replies: 9
    Last Post: 04-22-2012, 11:44 PM
  6. [SOLVED] Excel should include flashing cells/block and marching ants like W
    By waholt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-21-2005, 02:05 PM
  7. Marching ants
    By news.microsoft.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2005, 02: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