title: Excel vb code stopped working (variable not defined)
body: <p>(DISCLAIMER: I'm not a programmer, I spend my time on serverfault, I'm just a lowly admin)</p>
  
  <p>We have an excel spreadsheet with vb code in it that was created in Office 2003.</p>
  
  <p>We've recently gone to Office 2007, and the spreadsheet continued to work as normal.</p>
  
  <p><strong>However, after installing service pack 2 for Office 2007 the spreadsheet now fails with an error stating : "variable not defined"</strong></p>
  
  <p>If I comment out the "Option Explicit" statement at the top of the code then the code works fine.</p>
  
  <p>What I don't understand is that when the error occurs it is occurring on something that isn't even a variable (unless I'm wrong?).</p>
  
  <p>Click the below image to see the screenshot:</p>
  
  <p><em><a href="http://filedb.experts-exchange.com/incoming/2009/06_w23/t144890/snip.JPG" rel="nofollow noreferrer">http://filedb.experts-exchange.com/incoming/2009/06_w23/t144890/snip.JPG</a></em></p>