Results 1 to 6 of 6

Working Macro not auto updating

Threaded View

  1. #1
    Registered User
    Join Date
    12-01-2011
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    7

    Working Macro not auto updating

    Hello All, and thanks for any feedback. This is in Excel 2013

    I have the following Macro in my workbook which does exactly what it is suppose to do when I run the macro,
    but it does not run on it's own like it suppose to do??? What did I do wrong here?

    Sub Worksheet_Change()
    Application.ScreenUpdating = False
        ActiveWorkbook.Worksheets("Clients").Sort.SortFields.Clear
        ActiveWorkbook.Worksheets("Clients").Sort.SortFields.Add Key:=Range("L2:L100" _
            ), SortOn:=xlSortOnValues, Order:=xlAscending, CustomOrder:="YES,NO", _
            DataOption:=xlSortNormal
        ActiveWorkbook.Worksheets("Clients").Sort.SortFields.Add Key:=Range("C2:C100" _
            ), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        With ActiveWorkbook.Worksheets("Clients").Sort
            .SetRange Range("A1:L100")
            .Header = xlYes
            .MatchCase = False
            .Orientation = xlTopToBottom
            .SortMethod = xlPinYin
            .Apply
        End With
        Application.ScreenUpdating = True
    End Sub
    Thanks for any input
    Last edited by cccote; 03-17-2014 at 07:57 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Working with Dates, VB MAcro to Auto Filter on last 7 days
    By Rikkdh in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-20-2013, 10:01 AM
  2. Updating pivot table filters through a macro has stopped working, help please
    By JasperTata in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2012, 09:53 AM
  3. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  4. Auto list updating not updating
    By khank in forum Excel General
    Replies: 8
    Last Post: 05-28-2011, 11:03 PM
  5. Auto Macro for updating Current Month
    By dandavis1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 05:37 AM

Tags for this Thread

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