Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error changing cells in VBA if a chart is active
I have some VBA code that selects a worksheet, then changes the value of some cells on that worksheet. That worksheet has some charts that reference those cells. If a user inadvertently has one of the charts selected when the macro is run, I get an error (Runtime Error "1004"). If the chart was not initially selected, the code runs fine. What is a good way to prevent this error? Is there a simple way to first deselect any charts? Using Excel 2000. Thanks, -- Rev |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error changing cells in VBA if a chart is active
I have an answer, at least a workaround.
By adding the line: Range("A1").Select Before manipulating any cells, I do not get the error. -- Rev "Revolvr" wrote in message news:Gr35b.11073$QT5.6852@fed1read02... I have some VBA code that selects a worksheet, then changes the value of some cells on that worksheet. That worksheet has some charts that reference those cells. If a user inadvertently has one of the charts selected when the macro is run, I get an error (Runtime Error "1004"). If the chart was not initially selected, the code runs fine. What is a good way to prevent this error? Is there a simple way to first deselect any charts? Using Excel 2000. Thanks, -- Rev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing an active cell format in VBA | Excel Discussion (Misc queries) | |||
Active X Error message | Excel Discussion (Misc queries) | |||
printing only active range (changing) | Excel Discussion (Misc queries) | |||
Changing active selection cursor | Excel Discussion (Misc queries) | |||
Changing Excel Icon in the Active Window | Excel Programming |