Hi guys,
I have used ranges that vary in size each week. These ranges have an xl continuous border around them. I need to compare each of these named ranges against all named ranges in the used area for the worksheet.
Regards
Hi guys,
I have used ranges that vary in size each week. These ranges have an xl continuous border around them. I need to compare each of these named ranges against all named ranges in the used area for the worksheet.
Regards
Last edited by jordan2322; 01-16-2012 at 08:37 PM.
So if 2 consecutive rows are duplicate, should it be ignored?
What if there are 4 rows of duplicate data? Which is the field to be checked for duplicates?
Why dont you attach a dummy file so we can help you through it easily?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
i just want to check between all the Bordered ranges for duplicates - duplicates can only appear directly underneath themselves.
Last edited by jordan2322; 01-16-2012 at 08:37 PM.
I guess you have edited your original question. I remember it having the requirement that only 3 rows of duplicates should be checked for. Will look thru ur attachment now.
On what basis should the rows be deleted? Based on color only?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks