Finding minimum value Using VBA

[Contruct]

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,
ConsMinimum Value.xlsmtruct

[arnelgp]

is function =Min(Range), not sufficient?

[Contruct]

How do I use it in my VBA macro so that it posts the minimum value each time?

[p45cal]

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.