Hello all, first post.

I'm working on a VBA program for a design project and have hit a bump in the process. I have a For...Next that searches through a spring catalog database and finds springs that fit withing a certain diameter. After it finds a spring that fits it determines if it provides a required spring force, the rest is irrelevant to this question. My problem is that as the code stands now as soon as 1 spring is found that fits, it outputs the information of the spring and stops. What I really need to do is have it run through all the possibilities (which I can already do) and keep track of all the springs that fit the requirements so I can have it output the BEST spring not the FIRST it finds. Any suggestions about how I can accomplish this without needing to use a bunch of variables to assign the values to? This project is for a private company project and I don't feel comfortable posting the code I have so far.

Sorry for the wordy post but any help is appreciated, example code isn't really necessary just trying to figure out what process I can use. Thank in advance for the help.