Results 1 to 27 of 27

Get Marching Ants Range

Threaded View

kev_ Get Marching Ants Range 12-22-2017, 07:11 AM
AB33 Re: Get Marching Ants Range 12-22-2017, 07:21 AM
Stormin\' Re: Get Marching Ants Range 12-22-2017, 07:25 AM
kev_ Re: Get Marching Ants Range 12-22-2017, 07:45 AM
AB33 Re: Get Marching Ants Range 12-22-2017, 07:50 AM
kev_ Re: Get Marching Ants Range 12-22-2017, 08:03 AM
Stormin\' Re: Get Marching Ants Range 12-22-2017, 08:44 AM
kev_ Re: Get Marching Ants Range 12-22-2017, 03:34 PM
xladept Re: Get Marching Ants Range 12-22-2017, 07:56 PM
kev_ Re: Get Marching Ants Range 12-23-2017, 04:14 AM
Sintek Re: Get Marching Ants Range 12-23-2017, 03:11 AM
kev_ Re: Get Marching Ants Range 12-23-2017, 03:17 AM
Sintek Re: Get Marching Ants Range 12-23-2017, 05:01 AM
xladept Re: Get Marching Ants Range 12-23-2017, 02:48 PM
kev_ Re: Get Marching Ants Range 12-23-2017, 04:45 PM
Sintek Re: Get Marching Ants Range 12-24-2017, 04:00 AM
kev_ Re: Get Marching Ants Range 12-24-2017, 03:13 PM
xladept Re: Get Marching Ants Range 12-24-2017, 03:44 PM
Winon Re: Get Marching Ants Range 12-24-2017, 04:18 PM
xladept Re: Get Marching Ants Range 12-24-2017, 04:39 PM
kev_ Re: Get Marching Ants Range 12-27-2017, 08:22 AM
xlnitwit Re: Get Marching Ants Range 12-27-2017, 08:26 AM
kev_ Re: Get Marching Ants Range 12-27-2017, 08:33 AM
xlnitwit Re: Get Marching Ants Range 12-27-2017, 08:51 AM
kev_ Re: Get Marching Ants Range 12-27-2017, 09:30 AM
xlnitwit Re: Get Marching Ants Range 12-27-2017, 09:38 AM
xladept Re: Get Marching Ants Range 12-27-2017, 12:29 PM
  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. 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. [SOLVED] 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