LinkBack URL
About LinkBacks
markusvirus 
Hi Experts,
I am trying to copy a code for highlighting duplicate rows. For some reason, I am getting an Error "Object Required". Can somebody check on my code please? I've attached it for reference.
Thank you!
Hi Experts,
I am trying to copy a code for highlighting duplicate rows. For some reason, I am getting an Error "Object Required". Can somebody check on my code please? I've attached it for reference.
Thank you!
Remove the word 'Set' in both places. You have the variable 'searchresult' declared as a String. When you use Set, VBA expects an Object. Also, for your rng variable, you have 'rnd' in the declarations. While it won't throw an error, you might want to fix it for sake of consistency.Originally Posted by markusvirus
Last edited by JLGWhiz; 12-24-2015 at 05:11 PM.
Hi markusvirus,
Just change the searchresult string variable to a range like so:
Regards,
Dim searchresult As Range
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Yep, that would probably be better, based on the rest of the code structure. I should have read the whole thing befoire.Hi markusvirus,
Just change the searchresult string variable to a range like so:
Regards,Dim searchresult As Range
Robert
Thank you so much kind sirs. I'll get back once I test it out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks