+ Reply to Thread
Results 1 to 2 of 2

Unselect Range of cells after sort

  1. #1
    Valued Forum Contributor
    Join Date
    03-28-2014
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    Excel 2016
    Posts
    702

    Unselect Range of cells after sort

    Hi,

    After sorting, The cells remain selected. How to Unselect the range

    I did try like
    set rng = Nothing,
    rng.ClearOutline,
    Application.CutCopyMode =False

    all of these seems does work and the range remain selected . Please don't tell me, Range("A1").select, it is not a solution.

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Unselect Range of cells after sort

    I tried executing the code on my sample data.. it worked perfectly.. nothing is selected after macro runs..

    can you share your sample file.. to see if what getting selected...
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

+ 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. dynamic named range, but unselect first set
    By amartino44 in forum Excel General
    Replies: 1
    Last Post: 08-16-2013, 02:59 PM
  2. [SOLVED] Unselect Range to top left cell
    By pkew22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2013, 01:49 PM
  3. Unselect Range
    By The Skipper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2013, 01:08 AM
  4. How to select/unselect range based on variables
    By kirba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2009, 04:00 AM
  5. [SOLVED] Unselect range
    By Biff in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-30-2005, 05: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