Thread
:
Max Function
View Single Post
#
2
Posted to microsoft.public.excel.programming
Frank Kabel
external usenet poster
Posts: 3,885
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.
Reply With Quote
Frank Kabel
View Public Profile
Find all posts by Frank Kabel