+ Reply to Thread
Results 1 to 3 of 3

How can I "deactivate" a range just used as a Copy source in VBA

  1. #1
    Registered User
    Join Date
    04-27-2009
    Location
    Bristow, VA
    MS-Off Ver
    Excel 2007
    Posts
    15

    How can I "deactivate" a range just used as a Copy source in VBA

    I have a VBA macro that copies two ranges to two other destinations. When the macro completes, the last source range (the cells that provided the data for the last copy), still are "dashed highlighted" in case they were going to be copied again. How can I get that "dashed highlighting" to disappear? (ESC does it when copying and pasting manually, but I can't figure out how to do it in VBA).
    Thanks,
    Steve

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

    Re: How can I "deactivate" a range just used as a Copy source in VBA

    Kill the marching ants:
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    04-27-2009
    Location
    Bristow, VA
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: How can I "deactivate" a range just used as a Copy source in VBA

    Thanks for the info. Love the description, marching ants. I had hidden the columns so I had them going in single-file, but it was still very distracting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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