HI
Pls go through the attachment. after running the code one number coming two times in the unique list. Pls help me.
regards
ajay
HI
Pls go through the attachment. after running the code one number coming two times in the unique list. Pls help me.
regards
ajay
The AdvancedFilter function uses the first cell in the filter range as a header. Your filter range starts at row A2. So the first value 101 is the header and not part of the unique list.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
As @AlphaFrog mentions, start your range at the headers not the first row of values.
Also not sure I see the need to use 2x For loops instead of a single one.
Would the above work in place of both For loops?Please Login or Register to view this content.
Also instead of:
I would recommend:Please Login or Register to view this content.
Please Login or Register to view this content.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Dear AlphaFrog,
Still i'm getting error. Pls rectify it.
thank you in advancePlease Login or Register to view this content.
regards
ajay
Last edited by ajaypal.sp; 02-15-2018 at 04:04 AM. Reason: Attachment Added
Are you not wanting to compare unique values to Col A and if > 1 then color???
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Just an alternative.
Please Login or Register to view this content.
Last edited by bakerman2; 02-15-2018 at 05:48 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks