Error changing cells in VBA if a chart is active

  • Thread starter Thread starter Revolvr
  • Start date Start date
R

Revolvr

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
 
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
 
Back
Top