Hi all,
I wrote this simple loop:
My Loop Until x2="" is receiving an 'object required' runtime error of 424...what am I doing wrong?Please Login or Register to view this content.
Thank you for your help!
Hi all,
I wrote this simple loop:
My Loop Until x2="" is receiving an 'object required' runtime error of 424...what am I doing wrong?Please Login or Register to view this content.
Thank you for your help!
If x1 = x2 you are deleting x2.
So there's no object to use here.
If you want to remove duplicates in Excel 2010 you can use Data>Remove duplicates.Please Login or Register to view this content.
If posting code please use code tags, see here.
Found my answer...simply restating my x2 in my if clause--that way I can automate the remove duplicates funtion, which was my goal.
Please Login or Register to view this content.
If you want to automate the remove duplicates function.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks