title: Switching from Range to Array and Back in a VBA Function
body: <p>There are a lot of questions, and a lot of responses dealing with Range/Array conversion in VBA. I haven't been able to find an answer that works, so I would really apreciate some help.</p>
  
  <p>Below is what I'm trying to do:</p>
  
  <pre><code>    Function RangeToArrayToRange(inputRange As Range) As Range
          Dim inputArray As Variant
          inputArray = inputRange
          'operations on inputArray'
          '...'
          Dim outputRange As Range
          outputRange = inputArray
          Set RangeToArrayToRange = outputRange
      End Function
  </code></pre>
  
  <p>Thanks in advance for your help!</p>