Hi beautiful people,
Following code is okey.
a = CLng(Evaluate("LARGE(N7:HM7,1)"))
Following code is not okey.
x = ActiveSheet.Cells(7, 14).Address
y = ActiveSheet.Cells(7, 221).Address
a = CLng(Evaluate("LARGE(x:y,1)"))
Thanks in advance.