Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sun, 11 Dec 2005 16:06:40 -0000, "Mike H" wrote:
Hello, I want a function that allows me to enter a range and then returns the address of the cell with the minimum value. It is the Address I am interested in, not the value. Any ideas? Many thanks Since I see this post in programming, I will assume you want a VBA solution: ==================================== Option Explicit Function MinCellAdr(rg As Range) As String Dim MinNum As Double MinNum = Application.WorksheetFunction.Min(rg) MinCellAdr = rg.Find(what:=MinNum, _ LookIn:=xlValues, lookat:=xlWhole).Address End Function ===================================== --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find last cell in range with data, display cell address | Excel Worksheet Functions | |||
find email address in a cell | Excel Worksheet Functions | |||
Is there a way to find the address of a cell with a certain value? | Excel Worksheet Functions | |||
Function to find the address of a cell | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions |