Results 1 to 12 of 12

delete entire row by vba

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2020
    Location
    india
    MS-Off Ver
    2013
    Posts
    221

    delete entire row by vba

    Hi Experts,
    I am looking for a macro that will do the below things

    Macro will be placed in macro.xlsm(so we have to open abc by a macro)
    If column E matches with Column F then delete that entire row by vba
    and save the changes & close the workbook
    File ABC.xls may be located anywhere in the pc, so plz hardcode the path in the macro,so that i can change it as per my needs in future

    Thnx For the Help

    Sample file attached below

    Hi Experts,
    I am looking for a macro that will do the below things

    Macro will be placed in macro.xlsm(so we have to open abc by a macro)
    If column B of DEF.xlsx matches with Column I of ABC.xls then delete that entire row
    and save the changes & close the workbook
    File ABC.xls & DEF.xlsx may be located anywhere in the pc, so plz hardcode the path in the macro,so that i can change it as per my needs in future

    Thnx For the Help

    Sample file attached below
    Attached Files Attached Files
    Last edited by davesexcel; 07-14-2020 at 11:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] delete entire row by vba if delete word is present
    By MoldyBread in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2020, 12:02 PM
  2. iCell.EntireRow.Delete not working. Need code to Delete Entire Row
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-27-2017, 10:48 PM
  3. [SOLVED] Macro Needed to Delete Entire Row if the Entire Row (Or Col A,B,C,D in row ) are blank
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2016, 06:32 AM
  4. VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2015, 07:48 AM
  5. Replies: 4
    Last Post: 10-12-2014, 08:54 AM
  6. [SOLVED] Delete cell only with certain critria. Don't want to delete entire row, the celsl only
    By RobertOHare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2013, 04:18 AM
  7. Delete entire row when cell says delete
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2007, 11:46 AM

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