Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's the code. It's within a subroutine which is called from serveral
other subroutines. I do a bit of EnableEvents and ScreenUpdating commands in my code for various reasons. Most of the time this code works. But some condition seems to exist that stops the 'range("D2").Select' from executing properly. Haven't seen this before and I do have quite a lot of code in Macros in many other Excel applictions. ============================================= Excel.ActiveSheet.ChartObjects("Chart 52").Activate Excel.ActiveSheet.ChartObjects("Chart 52").Select Excel.Sheets("InterActive Chart").Range("D2").Value = "X3" Excel.Sheets("InterActive Chart").Range("D2").Select =============================================== The first 3 lines work properly, but I have no idea what Excel or VBA is doing when I execute line 4. It does nothing, and I don't know where the cursor is. Any suggestions would be welcome. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA: Column Select then Data Select then return to cell A1 | Excel Discussion (Misc queries) | |||
Select max value from 9 cells, copy cell col heading to other cell | New Users to Excel | |||
Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) |