Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using WorksheetFunction.Max()
I have a worksheet where A1:A10 is a named range "Line"
and C1:C10 is named "Qty". Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"") The worksheet function =Max(Line) will return the highest value in the range "Line". When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0 (zero). How can I correctly use the code to match the results of the worksheet function? Thanks very much. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using WorksheetFunction.Max()
Try this
WorksheetFunction.Max(Range(Line)) The names on the worksheet are just strings like "A1:G7" which is not a range. "Dave" wrote: I have a worksheet where A1:A10 is a named range "Line" and C1:C10 is named "Qty". Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"") The worksheet function =Max(Line) will return the highest value in the range "Line". When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0 (zero). How can I correctly use the code to match the results of the worksheet function? Thanks very much. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using WorksheetFunction.Max()
try this
WorksheetFunction.Max(range("Line")) -- Gary "Dave" wrote in message ... I have a worksheet where A1:A10 is a named range "Line" and C1:C10 is named "Qty". Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"") The worksheet function =Max(Line) will return the highest value in the range "Line". When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0 (zero). How can I correctly use the code to match the results of the worksheet function? Thanks very much. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using WorksheetFunction.Max()
Hi Dave,
WorksheetFunction.Max(Range("Line")) Using line the way you did VBA thinks that it is a VBA variable not a named range. Regards, OssieMac "Dave" wrote: I have a worksheet where A1:A10 is a named range "Line" and C1:C10 is named "Qty". Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"") The worksheet function =Max(Line) will return the highest value in the range "Line". When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0 (zero). How can I correctly use the code to match the results of the worksheet function? Thanks very much. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using WorksheetFunction.Max()
I've struggled with understanding when to use quotes and when not to.
Thanks to all for the help. "OssieMac" wrote: Hi Dave, WorksheetFunction.Max(Range("Line")) Using line the way you did VBA thinks that it is a VBA variable not a named range. Regards, OssieMac "Dave" wrote: I have a worksheet where A1:A10 is a named range "Line" and C1:C10 is named "Qty". Each cell in "Line" has the formula =IF(ISNUMBER(Qty),ROW(),"") The worksheet function =Max(Line) will return the highest value in the range "Line". When I try to use WorksheetFunction.Max(Line) in VBA, it always returns 0 (zero). How can I correctly use the code to match the results of the worksheet function? Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WorksheetFunction help | Excel Discussion (Misc queries) | |||
Worksheetfunction help | Excel Programming | |||
worksheetfunction | Excel Programming | |||
Worksheetfunction | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming |