Results 1 to 4 of 4

Find function or method to delete rows

Threaded View

  1. #1
    Registered User
    Join Date
    02-04-2021
    Location
    Csatar
    MS-Off Ver
    Microsoft Office Professional Plus 2024 MSO (2410 build version16.0.18129.20100)
    Posts
    30

    Find function or method to delete rows

    Hi, I am looking for a function that compares the range A:A of the 'From' worksheet with the same range of the 'To' worksheet. And delete the rows in the 'to' worksheet that are not in the 'From' worksheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-15-2018, 02:02 PM
  2. Deleting rows in table give me run time error delete method of range class failed
    By jhuvba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-17-2015, 04:37 PM
  3. Macro To Find Rows With Duplicates, Compare Cells, And Delete Rows. - Excel
    By Kwame001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2013, 10:41 AM
  4. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  5. method 'range' of object '_global' failed - find function sometimes fails?
    By n1210933 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2010, 06:17 AM
  6. Method to find discrepancy in sumif function
    By mingali in forum Excel General
    Replies: 1
    Last Post: 09-05-2009, 02:19 PM
  7. Replies: 3
    Last Post: 08-09-2009, 07:48 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