I have Column A which is populated by various numbers resulting from a vast range of VLOOKUP's and formulas. One of these formulas has a variable which changes the results in Column A. I'm trying to find what number for this variable will yield a number for Column A which I know. This known number is the limit.

I would like to create a macro or UDF which will add iteratively to the variable starting from 0 and go up in 0.00001 increments until the limit is reached in Column A. Column A is very dynamic from all the other input components so it varies with every change.

I would appreciate any guidance in creating such a macro or UDF. From what I've read, I think I'm looking for a macro or UDF with a 'loop'.

So in summary I'm looking for something which will try 0.0001, then 0.0002 ...... until my known low limit number is reached in Column A, then the macro must stop.

Thanks,
P