title: Extract the text from string between the last and the paired brackets
body: <p>I'm trying to extract the last group bounded by brackets from the string.
  The string could be like one of these variants:</p>
  
  <pre><code>String                             ' Extracted sub
  --------------                     ' -------------
  Some (text)                        ' text
  Some text                          ' "" or "Some text"
  Some (text) (here)                 ' here
  Some (text) (is situated (here))   ' is situated (here)
  Some text (is situated (here))     ' is situated (here)
  Some (text) (is (situated (here))) ' is (situated (here))
  </code></pre>
  
  <p>I need the <code>substring</code> between the last closing bracket and the corresponding opening bracket.</p>
  
  <p>All variants of <code>Split</code>, <code>Mid</code>, <code>InStr</code> and <code>InStrRev</code> I tested... </p>