+ Reply to Thread
Results 1 to 4 of 4

Cant figure out how to automatically sort specific cells.

  1. #1
    Registered User
    Join Date
    10-22-2017
    Location
    Jacksonville, FL
    MS-Off Ver
    365
    Posts
    25

    Cant figure out how to automatically sort specific cells.

    Dear Friends,

    I have found several ways to autosort Columns with macros. I can't find a way to autosort a select block of cells with Macros. I am making a calendar. When I click on a date. I want to enter the time on that Calendar date, enter data, and then have macros auto sort the times for that date only. For instance I want to auto sort cells C7:C13 only. Hope that somebody can help.

    Bob

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    3,096

    Re: Cant figure out how to automatically sort specific cells.

    .
    Please Login or Register  to view this content.
    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

  3. #3
    Registered User
    Join Date
    10-22-2017
    Location
    Jacksonville, FL
    MS-Off Ver
    365
    Posts
    25

    Re: Cant figure out how to automatically sort specific cells.

    Thank you for your help. Unfortunately I keep getting a Complile Error: Expected end sub with the macro. What am I doing wrong?

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    3,096

    Re: Cant figure out how to automatically sort specific cells.

    .
    Paste the macro into a Routine Module. Activate the macro with a command button attached to the macro.
    Attached Files Attached Files
    Last edited by Logit; 04-16-2018 at 11:58 AM.

+ 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