Consulting

Results 1 to 4 of 4

Thread: Finding minimum value Using VBA

  1. #1
    VBAX Newbie
    Joined
    Jan 2022
    Posts
    2
    Location

    Finding minimum value Using VBA

    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

  2. #2
    is function =Min(Range), not sufficient?

  3. #3
    VBAX Newbie
    Joined
    Jan 2022
    Posts
    2
    Location
    How do I use it in my VBA macro so that it posts the minimum value each time?

  4. #4
    Knowledge Base Approver VBAX Wizard
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,535
    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.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •