+ Reply to Thread
Results 1 to 3 of 3

If target = 0, then Delete Specific Cells on the same Row

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    25

    If target = 0, then Delete Specific Cells on the same Row

    Hi Guys,
    I'm Trying to write a code to delete Value in Column E & F If value in Column A = 0. (same row)

    I've tried a few methods but none of them work.
    I'm wondering if someone here is kind enough to write an example Macro/VBA coding for this.

    Thanks guys,

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: If target = 0, then Delete Specific Cells on the same Row

    Like this perhaps?

    Please Login or Register  to view this content.
    Alf

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: If target = 0, then Delete Specific Cells on the same Row

    Thanks for rep.

    Alf

+ 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(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
  2. [SOLVED] Find cells which contain specific word, delete cells and shift left.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2012, 07:00 AM
  3. [SOLVED] Help with modifying code to copy specific cells on target row instead of the whole row
    By Spookman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2012, 05:22 AM
  4. Delete cells with a specific value
    By agupta in forum Excel General
    Replies: 35
    Last Post: 09-22-2011, 01:15 PM
  5. [SOLVED] Delete specific cells contents in a row with some locked cells in the same row
    By trussman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2005, 03: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