| 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 |
| 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) | |||
Threaded Mode
