Error changing cells in VBA if a chart is active

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
 
R

Revolvr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top