Results 1 to 27 of 27

Get Marching Ants Range

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Get Marching Ants Range

    User selects a range and hits {CTRL} c
    - the range to be copied is surrounded by the familiar marching ants

    What is the VBA to return that range?
    (either as string or range)

    thank you



    TO CLARIFY

    I want to capture the "marching ants" range even if user has moved to another cell
    - "marching ants" still remain around the original range
    Last edited by kev_; 12-23-2017 at 03:20 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [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
  2. 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
  3. 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
  4. Replies: 9
    Last Post: 04-22-2012, 11:44 PM
  5. [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
  6. 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