title: VBA calling a function not directly using
body: <p>I have two functions. Users call first function (<code>FunctOne</code>), in Excel, and select a range of inputs an perform something. A second function (<code>FunctTwo</code>) uses this partial output and it performs something more. I want to show <code>FunctTwo</code> output.</p>
  
  <p>My question is: how can I show the result of the <code>FunctTwo</code>? Do I need to create a third function? if yes, How does it look like?</p>
  
  <p>Thanks a lot,</p>
  
  <pre><code>Function FunctOne(var1, var2 As Range)
  
  Do something 'perform some calculations using inputs
  
  End Function
  </code></pre>
  
  <p>===========</p>
  
  <pre><code>Function FunctTwo(FunctOne As Variant) As Variant
  
  Do something 'use the output of FunctOne and do something
  
  End Function
  </code></pre>
  
  <p>PD: I tried to do all in just one function, but the loop doesn't work as I expected. So, maybe if I change my approach using two functions it might work. Any help would be appreciated.</p>