title: Libreoffice calc: loop throught cells macro
body: <p>I've been searching a lot but could find little to no info about LibreOffice Basic</p>
  
  <p>I'm a bit used to programming macros in excel but this time a need to do a loop until i reach the first empty column and it needs to be in libreoffice.</p>
  
  <p>In excel i would do something like this:</p>
  
  <pre><code>Dim i As integer
  
  i = 0
  Range("A1").Select
  While cell.Offset(0, i).Value &lt;&gt; Null
      i = i + 1
  Wend
  MsgBox ("First empty column is " &amp; Chr(i + 64))
  </code></pre>
  
  <p>But in libreoffice i have no idea.</p>
  
  <p>Can anyone help me.</p>
  
  <p>Thanks,
  Bruno</p>