VBA Count Function

[Ark68]

I wish to assign variable mcnt2 to the value of the number of values in a named range. The name of the range is "Modlist2".

I am struggling on how to write the formula in VBA.

mcnt2 = range("Modlist2").Count

... isn't the way apparently.

 

[Tetra201]

Try

mcnt2 = WorksheetFunction.Count(Range("Modlist2"))