First step
What I am trying to do is I have a range which I need to find the lowest value greater than 0

Second step
Then get the content of a range in that row and display in different cells
I haven't started step to still trying to resolve step 1

Public Sub lowerstNSW() Dim x, Rng1 Dim excel As New Microsoft.Office.Interop.Excel.Application Rng1 = Globals.Sheet1.Range("E16:E30") x = excel.Min(Rng1) If x = 0 Then x = excel.Evaluate("=MIN(IF(" _ & Rng1.Address & ">0," _ & Rng1.Address & "))") End If Globals.Sheet1.Range("K2").Value = x End Sub

OK - I've had a closer look at your screenshot and I think I can see what you want, so try this:
(CODE)
I I was writing this from scratch I would get rid of all the literal cell references and parameterise

Public Sub lowerstNSW() Dim x As Integer Dim Rng1 As Range Set Rng1 = Range("E16:E30") x = excel.Evaluate("=MIN(IF(" _ & Rng1.Address & ">0," _ & Rng1.Address & "))") Sheet1.Range("K2").Value = x End Sub

Here is the code that will return non-integer numbers :

Public Sub lowerstNSW() Dim x As Double Dim Rng1 As Range Set Rng1 = Range("E16:E30") x = Excel.Evaluate("=MIN(IF(" _ & Rng1.Address & ">0," _ & Rng1.Address & "))") Sheet1.Range("K2").Value = x End Sub

I may be missing something here, but why not just put the formula into cell K2 in one step like this:

Public Sub lowerstNSW() Dim x As Double Dim Rng1 As Range Set Rng1 = Range("E16:E30") Range("K2").FormulaArray = "=MIN(IF(" & _ Rng1.Address & ">0," & Rng1.Address & "))"End Sub

After years of analyzing threat actor behavior, itâ€™s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

I'm not quite clear exactly what you want here - I am assuming it is some sort of lookup from the row where the min value occurs.

I suggest you raise this as a new question with a proper explanation and close this one (awarding points as necessary!), as there should really only be one question per thread.

OK - I've had a closer look at your screenshot and I think I can see what you want, so try this:

Public Sub lowerstNSW() Dim x As Double Dim rngRef As Range Dim Rng1 As Range Dim rngMatch As Range Set rngRef = Range("C16:E30") Set Rng1 = rngRef.Columns(3).Cells Range("K2").FormulaArray = "=MIN(IF(" & _ Rng1.Address & ">0," & Rng1.Address & "))" ' get the row in the reference range where this value was found ' you can hide the column later if you want Set rngMatch = Range("L2") rngMatch.FormulaR1C1 = "=Match(RC[-1]," & Rng1.Address(True, True, xlR1C1) & ",0)" ' lookup the number (box?) from the ref range Range("I2").Formula = "=Index(" & rngRef.Address & "," & _ rngMatch.Address & ",1)" ' lookup the name from the ref range Range("J2").Formula = "=Index(" & rngRef.Address & "," & _ rngMatch.Address & ",2)"End Sub

I I was writing this from scratch I would get rid of all the literal cell references and parameterise the routine a bit so that it was easier to change to locations in the future, but I think this illustrates the principle.

Sorry - meant to say that this does not address what would happen if the minimum value occurred 2 or more times in the reference table - this would just find the first one.

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Introduction
This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm),
I will briefly cover:
1) An overvieâ€¦

Introduction
While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful. I tested several solutions and share the results in this article as well as tâ€¦

The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.