+ Reply to Thread
Results 1 to 3 of 3

Worksheet_Change Event if delete target then delete the formulas

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,008

    Post Worksheet_Change Event if delete target then delete the formulas

    hello, evryone

    i am using below code to add formulas auto

    Please Login or Register  to view this content.
    i want little change in above code

    if i delete any data from range or multiple range from range then delete the formulas too

    thanx
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: Worksheet_Change Event if delete target then delete the formulas

    Well the first line makes the code stop if you have multiple cells changing at the same time... but we can fix that. You say if you delete any data from range or multiple range, then delete formulas too....
    But what does range or multiple range mean? If you delete data from cells in column C then delete formulas?

    Also, this very long line:

    Please Login or Register  to view this content.
    can just be:

    Please Login or Register  to view this content.
    Last edited by Arkadi; 02-09-2017 at 09:52 AM.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,006

    Re: Worksheet_Change Event if delete target then delete the formulas

    My guess is you want something like this?:

    Please Login or Register  to view this content.

+ 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 - second part not working since Target is already being defined
    By ther3cruit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2015, 04:01 PM
  2. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  3. [SOLVED] Worksheet_Change Event - Target.Name.Name error in certain situations
    By GazP in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2013, 04:14 AM
  4. capture the name of the target passed into Worksheet_Change event
    By Isabel Lopatin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2013, 01:06 AM
  5. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  6. worksheet_change event delete contents
    By parlove in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2008, 07:46 PM
  7. [SOLVED] How to trap delete row event and hide column event?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2005, 12: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