title: Executing build-in functions from VBA (Excel)
body: <p>I need to have a capability to execute any kind of build-in functions (such as 'sum' or 'len') from VBA (MS Excel). </p>
  
  <p>One of the restrictions that I have is that I may not pass cell ranges as arguments to these functions. Instead of this, I should be able to use strict values. </p>
  
  <p>I want to be able to use the following expression SUM(1, 2) which should return 3, while the following version SUM("A1:A2") won't work for me. </p>
  
  <p>I managed to develop some function that parses my prior input and makes it consist of a list of values (as for example above, it made the user's input of 'A1:A2' look like an array of numbers consisting of two values). </p>
  
  <p>So, can anyone give me an example of using a build-in function that receives a list of values (not just range of cells)? </p>
  
  <p>I tried the following code, but for some unknown reason, I haven't been able to get it working (I keep getting 1004 error, saying: Cannot run the macro 'SUM'. The macro may not be available in this workbook or all macros may be disabled.): </p>
  
  <pre><code>Application.Run "SUM", 2, 2
  </code></pre>
  
  <p>Some valuable advices that would help to find a solution to this problem will be greatly appreciated. </p>