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.

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.

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.
.