Try the below; with the sample data below

Range("B1") = WorksheetFunction.Large(Range("A1:A10"), 2)

ColA
1
2
3
4
5
6
7
8
10



If this post helps click Yes
---------------
Jacob Skaria


"jswalsh33" wrote:

I am trying to use the Excel Worksheet Function LARGE in a macro.

My code is Cells(2, 15) = Application.WorksheetFunction.Large(Array, n) in
Excel 2003.

I have tried every way I can think of to write the array but all array
nomenclature I have tried results in a compile error.

Help?

Jim Walsh