E
EagleOne
2003/2007
Using 2007
Dim StartSearch as Long (Value preceeding line below is 13)
Dim FormulaStr as String (Value preceeding/after line below is 123]
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
StartSearch = IIf(InStr(StartSearch, FormulaStr, "'!") = InStr(StartSearch, FormulaStr, "'"), _
InStr(StartSearch, FormulaStr, "'!") + 2, InStr(StartSearch, FormulaStr, "'") + 1)
In the Code Window, this line does not change the next StartSearch value from 13 to 46.
Also, no error message is displayed.
But if I copy/paste/execute the same line in the Immediate Window StartSearch chages
from 13 to 46 as it should.
What am I missing? or is there a Bug in 2007?
TIA EagleOne
Using 2007
Dim StartSearch as Long (Value preceeding line below is 13)
Dim FormulaStr as String (Value preceeding/after line below is 123]
Application.DisplayAlerts = True
Application.ScreenUpdating = True
Application.Calculation = xlAutomatic
StartSearch = IIf(InStr(StartSearch, FormulaStr, "'!") = InStr(StartSearch, FormulaStr, "'"), _
InStr(StartSearch, FormulaStr, "'!") + 2, InStr(StartSearch, FormulaStr, "'") + 1)
In the Code Window, this line does not change the next StartSearch value from 13 to 46.
Also, no error message is displayed.
But if I copy/paste/execute the same line in the Immediate Window StartSearch chages
from 13 to 46 as it should.
What am I missing? or is there a Bug in 2007?
TIA EagleOne