Results 1 to 4 of 4

Autosort release Select

Threaded View

RobertCo Autosort release Select 09-14-2009, 11:38 PM
JBeaucaire Re: Autosort release Select 09-14-2009, 11:45 PM
RobertCo Re: Autosort release Select 09-14-2009, 11:56 PM
JBeaucaire Re: Autosort release Select 09-15-2009, 10:32 AM
  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    33

    Autosort release Select

    Hello everyone, its been a while

    I have a spreadsheet has multiple sheets.
    On sheet 1 values are entered and formulas applied

    On sheet three formulas read from sheet one and are updated automatically

    I have added an AutoSort capabilty by
    pressing Alt-F11 and choosing worksheet

    then I entered in the following code


    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("A2:H5").Select
    Selection.Sort Key1:=Range("C2:C5"), Order1:=xlDescending, Key2:=Range("A2:A5"), Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal
    End Sub
    The sort is working as expected however, I do not have access to the page anylonger to make changes.
    I am not sure how to release the Select once the page autosorts.

    Any ideas ?

    Thank you
    Last edited by RobertCo; 09-14-2009 at 11:55 PM.

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