referring to user selected range in VBA function

Hi Xelhelp,

You have to put user-defined functions in standard modules, not within sheet modules. In the VB Editor click Insert > Module and put the code there. You should then be able to use your formula in the worksheets.

Rather than having me explain the differences, there's volumes of information within this forum and by doing simple searches on Google.

http://www.techbookreport.com/tutorials/excel_vba1.html
http://www.cpearson.com/excel/writin...ionsinvba.aspx
http://www.xlpert.com/partE.htm
etc..

Without 'Application.' before 'WorksheetFunction.Sum' VBA apparently doesn't know what object you're referring to.

http://www.cpearson.com/excel/callin...ionsinvba.aspx

A sheet module is typically used to store code that relates to that worksheet and events within that worksheet. A standard module is used to store code that you typically use from any worksheet in the workbook (or reference from other workbooks). There is also the ThisWorkbook module, which typically is used to store workbook-level event code (such as a change event that you want to occur on all worksheets, not just one).

This is a very basic explanation, to be sure, but there's a ton of information out there on the subject. (Never memorize anything that you can look up.™)

you also spelled worksheetfunction wrong the first time.