+ Reply to Thread
Results 1 to 2 of 2

Remove duplicate rows in column

  1. #1
    Registered User
    Join Date
    07-01-2015
    Location
    Antwerp
    MS-Off Ver
    2019
    Posts
    43

    Remove duplicate rows in column

    Hi

    I have a script that logs cell A5 values (generated by a formula) into column C before refreshing the workbook.
    I want to remove all the refreshed duplicates in this column, but the script below seems to get stuck in an infinite loop.
    How could the "remove duplicate rows in column C" code be rewritten to prevent it from looping?

    Please Login or Register  to view this content.
    Also see https://www.mrexcel.com/board/thread...2#post-5898587
    Last edited by Retroshift; 06-11-2022 at 06:29 PM.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,211

    Re: Remove duplicate rows in column

    Possibly...
    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. Sum a column if there is a duplicate in another and remove blank rows
    By JodiBlack in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2021, 11:33 PM
  2. [SOLVED] Remove Duplicate Rows comparing entries in a single column
    By kdraghu in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 06-02-2020, 10:15 AM
  3. Remove rows if duplicate in same column.
    By excelfriend1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-19-2016, 08:18 PM
  4. Replies: 4
    Last Post: 01-08-2016, 09:21 AM
  5. Remove duplicate rows and move the column data to a new column
    By cmray58 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-22-2015, 03:46 PM
  6. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  7. excel macro to remove specific columns and rows + remove duplicate
    By garrywelson in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-17-2013, 12:03 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