| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Min value in range with VBA?
That should more than seem to work - I just didn't know how you were
referencing the workbook and worksheet objects. HTH, Bernie MS Excel MVP Thanks! That really helped. Here's what seems to be working for me (still testing)... dblMin = xlapp.WorksheetFunction.Min(xlapp.Workbooks(strXls File).Worksheets(i).Range( strRange)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| Find the MAX number in range, then find... | Excel Discussion (Misc queries) | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Find first cell in range and expand range -VBA | Excel Programming | |||
Threaded Mode
