+ Reply to Thread
Results 1 to 3 of 3

Repeating Worksheet Change Event on Different Ranges

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    20

    Repeating Worksheet Change Event on Different Ranges

    I have this code that will update the "Monthly Subtotal" on row 16 whenever data in cells on rows 10-14 are changed. It is working fine. What I would like help with is taking this code and applying it to calculate data in rows 18-22 and return the "Monthly Subtotals" for that set of data in row 24. The format is identical and the data is simply shifted down a number of rows. I already have changed the references in the code that is currently working on rows 10-14 but don't know how to incorporate it into the original worksheet_change code. I've attempted to do so but am getting erratic behavior as the syntax is not correct. If anyone would be willing to help cut and paste and make any adjustments to make this functional it would be greatly appreciated. Here is the code and I've attached a sample workbook as well.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Tanooki; 12-22-2014 at 09:44 PM.

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Repeating Worksheet Change Event on Different Ranges

    hi Tanooki, basing on your code:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    11-06-2014
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    20

    Re: Repeating Worksheet Change Event on Different Ranges

    Thank you very much Watersev. I didn't expect a reply so quickly. I am going to attempt to add the third batch of data to the code tomorrow. I may have a couple more questions if I have issues. Anyhow a sincere thanks again for your help.

+ 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. [SOLVED] Worksheet change event applying to multiple ranges
    By MaddyG in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-29-2013, 12:04 PM
  2. [SOLVED] Worksheet change event to Formulate Cells for multiple Ranges
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-15-2012, 02:38 PM
  3. Worksheet Change event ignore change event
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 12:29 PM
  4. Worksheet Change Event-change event to trigger
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2005, 06:05 PM
  5. [SOLVED] Worksheet Change event code moved to Worksheet Calculate event... and it's not working
    By KimberlyC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-23-2005, 06:05 PM

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