Excel.au3 Error

[MacBain00]

I'm trying to activate a Sheet on an Excel File with the below code

Non-working Code

Local $sExcelSheets = ""
    Local $aExcelSheets = _ExcelSheetList($oExcel)
    
    If $switch = "SUAW" Then
        For $i = $aExcelSheets[0] To 1 Step -1 ;Work backwards through loop
            If StringInStr($aExcelSheets[$i], "Approv") Then ;Using the String Name returned in the Array Elements
                $sExcelSheets = $aExcelSheets[$i]
            EndIf
            If $sExcelSheets <> "" Then ExitLoop
        Next
    ElseIf $switch = "UserLoader" Then
        For $i = $aExcelSheets[0] To 1 Step -1 ;Work backwards through loop
            If StringCompare($aExcelSheets[$i],"Users")=0 Then ;Using the String Name returned in the Array Elements
                $sExcelSheets = $aExcelSheets[$i]
            EndIf
            If $sExcelSheets <> "" Then ExitLoop
        Next
    EndIf
    If $sExcelSheets = "" Then
        _ErrorProgressBar()
        MsgBox(0, "Error", "   Unable to find the correct tab.   ")
        Exit
    Else
        _ExcelSheetActivate($oExcel, $sExcelSheets)
        _Main()
    EndIf

What's odd is that as standalone code it works without any errors (below). With the rest of my code I get the below error:

$oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value = $sValue

$oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value = $sValue^ ERROR

Any help is appreciated.

Working Temp Code

#include <Excel.au3>
#include <Array.au3>

  $oExcel = _ExcelBookOpen(@DesktopDir & "\Users.xls")
  Local $sExcelSheets = ""
  Local $aExcelSheets = _ExcelSheetList($oExcel)
  For $i = $aExcelSheets[0] To 1 Step -1 ;Work backwards through loop
    If StringCompare($aExcelSheets[$i],"Users")=0 Then ;Using the String Name returned in the Array Elements
      $sExcelSheets = $aExcelSheets[$i]
    EndIf
    If $sExcelSheets <> "" Then ExitLoop
  Next
  _ExcelSheetActivate($oExcel, $sExcelSheets)
Exit

[nekkutta]

could it be you're using exitloop instead of continueloop?

[MacBain00]

could it be you're using exitloop instead of continueloop?

I ExitLoop if the Tab matches the name so that's working as expected. Plus it's the same in the standalone vs the bulk code. The standalone works as is.

WEIRD

[MacBain00]

Never mind guys. I put a few stops in and found that it's erroring in a totally different section. BUMP.