Using WorksheetFunction.Mode

[Wordsss]

I am having trouble using the Mode function (to determine the most repeated value in a group)
the line that fails on execution is the following:

[b96].Offset(statistic, Var + (country - 1) * 8) = WorksheetFunction.Mode(rango)

where

rango = Workbooks("na_data.xlsx").Worksheets(3).[a1].Offset(fil_1 + dif + 10 * i, col).Resize(10, 1)

rango is a vector containing numbers in each of its 10 cells

The error states "Unable to get Mode property of WorksheetFunction class”

Can anybody find where is the flaw in this code?

Thanks in advance

[protonLeah]

(How to) Attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"