Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone point me in the right direction for this?
Function Showme(rngSrc As Range) As String Dim rng As Range, rngMin As Range, dbl As Double, rngLeft As Range Dim intOffset As Integer Set rngMin = rngSrc.Cells(1, 1) dbl = rngMin.Value For Each rng In rngSrc If rng.Value < dbl Then Set rngMin = rng dbl = rngMin.Value End If Next 'Showme = rngMin.Address Set rngLeft = rngMin.Offset(, -3).Cells(1, 1) 'MsgBox rngMin.Address 'MsgBox rngLeft.Address 'MsgBox rngLeft.Value Showme = rngLeft.Value End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visual Basic Function works fine in Excell 2003 but not in Excel 2 | Excel Discussion (Misc queries) | |||
Macro hangs up often but sometimes works fine | Excel Worksheet Functions | |||
Macro works fine on PC; fails on Mac | Excel Programming | |||
Works fine in debug, but... | Excel Programming | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions |