This should be easy, frequent appeared #

[rplim2016]

Hello Mr. Excel users!

Function abce(mySheet As String, mySELEC As Range) As StringApplication.Volatile
Dim x As Range
    For Each x In mySELEC
        Debug.Print Sheets(mySheet).Cells.Find(what:=x.Value, MatchCase:=True, LookAt:=xlWhole).Row
    Next x
End Function

-above code is working and giving me each ROW # in immediate window through debug.print
-i know there is a "MODE", but how would i incorporate it in this function?
-i want this function just to give me the most frequent row number, so I can use that as my target in other codes.

result should be an integer row # only.

1
1
1
2

in above case the most frequent row # appeared is 1, so i want the result to be just # 1.

thank you!

 

[rplim2016]

i figured it out, but there's another problem

Dim totals(1 To 60) As Integer

abce = Application.WorksheetFunction.Mode(Array(totals(1), totals(2), totals(3), totals(4), _
                                        totals(5), totals(6), totals(7), totals(8)))

for above, i'll do totals up to 60, but if the totals has no row #, it gives an answer to 0.

then the most frequent # is 0.

how should i set if the totals is to ignore if zero?