+ Reply to Thread
Results 1 to 2 of 2

Only update if some cells change

Hybrid View

  1. #1
    Registered User
    Join Date
    06-12-2009
    Location
    Olofström, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    8

    Only update if some cells change

    Hi

    If a cell in coulmn B changes value then a macro should be run.
    As for now i have used workbook_change but that's not good because i need to change
    other columns without running the macro.
    How could i do that?

    //Johan

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Only update if some cells change

    Private sub worksheet_change(byval target as range)
    if not intersect(target,Range("B:B")) is nothing then
      'code here
    end if
    end sub

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. UDF does not update upon sheet change
    By gibsogu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-20-2013, 01:19 PM
  2. Replies: 2
    Last Post: 11-16-2012, 01:44 PM
  3. [SOLVED] update button on userform does not update all cells in worksheet
    By tutke in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-27-2012, 03:07 AM
  4. HYPERLINK doesn't update urls when input cells change
    By sarah.k in forum Excel General
    Replies: 2
    Last Post: 03-04-2009, 01:53 PM
  5. [SOLVED] Update on change
    By myleslawrence in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-17-2005, 09:06 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