title: Need some explanation on the VBA script
body: <p>i need some explanatory help on this code</p>
  <pre><code>EqptCode = .Range(&quot;A&quot; &amp; j)
  StartPos = InStr(1, EqptCode, &quot;&gt;&quot;)
  LastPos = InStr(2, EqptCode, &quot;&lt;/&quot;)
  CharNo = Len(EqptCode) - (Len(EqptCode) - LastPos + 1) - StartPos
  EqptCode1 = Mid(EqptCode, StartPos + 1, CharNo)
  </code></pre>
  <p>anybody know what's the meaning of +1 in VBA language? is it something to do with rounding up?</p>
  <p>Thanks in advance</p>