Results 1 to 12 of 12

Macro for running a macro when any cell in a range of cells changes

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    India
    MS-Off Ver
    Excel 2002
    Posts
    53

    Wink Macro for running a macro when any cell in a range of cells changes

    Hello Experts,

    Greetings. I am thankfull for all the supports you provide. As usual, I need your support to generate a macro.

    I have Sheet1, in which Cells D14 to C20 are the targets. If any of these cells changes, I want to run the following macro.
    Sub Button11_Click()
    '
    ' Button11_Click Macro
    ' Macro recorded 12-25-2013 by gmk
    '
    ' Keyboard Shortcut: Ctrl+f
    '
        ActiveWindow.SmallScroll Down:=-9
        Range("C14:D20").Select
        Selection.Copy
        Range("C31").Select
        Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
            xlNone, SkipBlanks:=False, Transpose:=False
        Application.CutCopyMode = False
        Selection.Sort Key1:=Range("D31"), Order1:=xlDescending, Header:=xlGuess _
            , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
            DataOption1:=xlSortNormal
    End Sub
    Can you please help me. My sincere thanks for all experts.

    Should I paste your program in the Module / Worksheet or in the Workbook?

    Regards,
    gm2612
    Last edited by Leith Ross; 12-25-2013 at 03:22 AM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to hide/unhide cells not running or running slow
    By mbp727 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 04:22 PM
  2. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 AM
  3. Running macro when a paste action is detected in a specific range of cell
    By Skell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2012, 01:39 PM
  4. running a macro to copy multiple cells from a row by selecting a cell
    By Healthwatch in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-28-2009, 02:30 PM
  5. [SOLVED] Running a macro if any data is entered in a range of cells
    By Jonathan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-16-2005, 04:45 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