Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min & Max w/o formula
Hi Again,
I am still working with charts, but this is simplier. With out putting a formula on a sheet, I want to evaluate a column for both it's min value and it's max value. I know how to do it with a formula placed into the sheet, but can code alone be used, no formula? Thanks Again, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min & Max w/o formula
David,
How's this? Sub test() Dim result As Long result = Application.Evaluate("MAX(A:A)") MsgBox result End Sub hth, Doug "David" wrote in message ... Hi Again, I am still working with charts, but this is simplier. With out putting a formula on a sheet, I want to evaluate a column for both it's min value and it's max value. I know how to do it with a formula placed into the sheet, but can code alone be used, no formula? Thanks Again, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min & Max w/o formula
Evaluate may be a bit of a hammer for this. Worksheetfunction works as well
worksheetfunction.max(range("A:A")) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Doug Glancy" wrote in message ... David, How's this? Sub test() Dim result As Long result = Application.Evaluate("MAX(A:A)") MsgBox result End Sub hth, Doug "David" wrote in message ... Hi Again, I am still working with charts, but this is simplier. With out putting a formula on a sheet, I want to evaluate a column for both it's min value and it's max value. I know how to do it with a formula placed into the sheet, but can code alone be used, no formula? Thanks Again, David |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bob and Doug
Bob and Doug,
Thanks to you both. Don't you love Excel, not just one way, but two? David -----Original Message----- Hi Again, I am still working with charts, but this is simplier. With out putting a formula on a sheet, I want to evaluate a column for both it's min value and it's max value. I know how to do it with a formula placed into the sheet, but can code alone be used, no formula? Thanks Again, David . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min & Max w/o formula
Thanks Bob.
Doug "Bob Phillips" wrote in message ... Evaluate may be a bit of a hammer for this. Worksheetfunction works as well worksheetfunction.max(range("A:A")) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Doug Glancy" wrote in message ... David, How's this? Sub test() Dim result As Long result = Application.Evaluate("MAX(A:A)") MsgBox result End Sub hth, Doug "David" wrote in message ... Hi Again, I am still working with charts, but this is simplier. With out putting a formula on a sheet, I want to evaluate a column for both it's min value and it's max value. I know how to do it with a formula placed into the sheet, but can code alone be used, no formula? Thanks Again, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |