Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA line of code executes in Immediate Window but not in Code Window
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA line of code executes in Immediate Window but not in Code Window
Hi,
Do you have a "sub..." /End sub? -- John johnf202 at hot mail dot com wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) | |||
IDE - 2003 - Cursor in Code window | Excel Discussion (Misc queries) |