Anyone want to take a shot at why I'm getting an "run-time error 1004 application definedd or object defined error at the beginning of my do until loop? I don't know if I'm right but I'm suspecting it may throw the error when it does not find a match?
Just assume CSNcol has a list of a few hundred numbers, and some have matches and some do not.
HTML Code:
I think I got it figured out with a For loop, but I'm open to other suggestions where it only replaces the row ONLY IF it finds 1 other match.
HTML Code:
If there is no match, your Do-Loop will loop until j is more than the max rows on your sheet and you will get that error. Try this...
Please Login or Register to view this content.
Please Login or Register to view this content.
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.
You may want to use the .Find method instead of nested loops. You will notice a speed improvement.
Find method
Thanks AF. That page looks extremely helpful right now. I'm going to give it a shot on a copy of this sheet I'm working right now.
You're welcome. If you do a search for something like VBA Find Method, you'll find many other useful guides and tutorials.Originally Posted by billyjo182
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks