Sub test()
MsgBox Range("c_name").Value ' defined name in excel
MsgBox Evaluate("SUM(A1:A10)")
MsgBox [SUM(A1:A10)]
End Sub