Hi,
I have a large spreadsheet that has some duplicates in Row Q. However, in column L there is a date. I want to be able to find the duplicates in column Q then delete the duplicate with the earliest date.
Please Login or Register to view this content.
Idont think you need the lrow-1 bit as youre stepping -1
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thanks! I tried that and it didn't work.
what is happening with your code. YOu should detail the error/discrepancy also.
I'm not getting an error. I removed the lrow-1 and the code doesn't do anything.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks