PDA

View Full Version : Finding minimum value Using VBA



Contruct
01-05-2022, 10:25 PM
Hi All,

I have a VBA macro that currently pulls a list of values from a application. From there, I make a graph and I visually see the minimum value from using a line plot to determine it.

I want to find a better way of finding this minimum value. I want to interpolate points that make the line and then find the minimum value automatically. Is there anyone that knows how this can be done?

Thanks,
Cons29285truct

arnelgp
01-06-2022, 12:51 AM
is function =Min(Range), not sufficient?

Contruct
01-07-2022, 08:33 AM
How do I use it in my VBA macro so that it posts the minimum value each time?

p45cal
01-07-2022, 10:24 AM
use
min=application.Min(your range or array here)
Since you don't include any code at all in your attachment it is impossible to advise more on how you'd actually (want) to use it.