| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Max Function
I want a variable to be set equal to the max number in my
B column. It isn't working. Here is what I have: NumberOfSubs= MAX(B3:"B" & FinalRow) FinalRow is my variable for the last row. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Max Function
Hi
try NumberOfSubs = application.worksheetfunction.max(Range("B3:B" & FinalRow)) -- Regards Frank Kabel Frankfurt, Germany wrote: I want a variable to be set equal to the max number in my B column. It isn't working. Here is what I have: NumberOfSubs= MAX(B3:"B" & FinalRow) FinalRow is my variable for the last row. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Max Function
You have your " in the wrong place. Try:
application.worksheetfunction.Max(range("b3:B" & x)) Pete -----Original Message----- I want a variable to be set equal to the max number in my B column. It isn't working. Here is what I have: NumberOfSubs= MAX(B3:"B" & FinalRow) FinalRow is my variable for the last row. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Linear Mode
