Results 1 to 8 of 8

Run macro if dynamic range changes

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-23-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    404

    Run macro if dynamic range changes

    Hi all,

    I'm having an issue with this one.

    I have uploaded an example workbook.
    I need a code which fires some other code
    MsgBox ("Test")
    whenever a range of cells change which are within 5 days of todays date. Hence, the msgbox would fire if anything in yellow was changed (B16:D21) and then tomorrow the range would be slightly different (B17:D22), etc

    Todays date will always be in A1.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro - Dynamic Copy Range
    By Lacaycer in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-28-2012, 03:23 PM
  2. Macro to do Calculations on a dynamic Range
    By psrs0810 in forum Excel General
    Replies: 5
    Last Post: 11-18-2010, 02:56 AM
  3. Dynamic Range for macro
    By soakaos in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2010, 05:20 PM
  4. Sum A Dynamic Range Affected By Macro
    By goldenbear10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2009, 04:51 AM
  5. Selecting dynamic range within macro.
    By NickMinUK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-03-2009, 06:25 AM

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