Hi,
I'm hoping you can help me identify where I'm going wrong with this loop. I am allocating stock to demand based on a catalogue number in one column and a contract in another.
This is my code. Don't get me wrong, it works, but it's very slow because of the number of iterations. I'm hoping to dramatically reduce this by doing something with the range.
Cheers Radddogg
Please Login or Register to view this content.
Last edited by radddogg; 09-08-2017 at 06:37 AM. Reason: added in line that might affect speed
Why not use Application.Match to identify rownumber of s on sheets Supply instead of looping every value in Column C ?
Once you found the record you can perform your other tests and do the rest of your stuff.
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.
How would I implement that? There could be 20 demands for that part and 20 inventory. Match would find me the first record, how would I move to the next?Originally Posted by bakerman2
One thing I thought was setting the "sRng" by matching d.value but again I can't think how to set it to all matching cells without using another loop to test the cell value.
Best to post example file so we have something to play with.
For anyone interested this is how I got it to only look at matching values
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks