locked
Chart Drawing RRS feed

  • Question

  • If I select a cell for my graph to be drawn in, and 1st delete the contents of cell, before drawing the graph, I get an error & the graph won't draw.

    But, if I don't do:  Selection.ClearContents   before drawing the graph, the graph draws fine.

    I don't get it, what's going on?

     

    Wednesday, March 31, 2010 2:50 PM

Answers

  • I've sorted this one.

    I don't know why the above happens but the following code gets me out of trouble.

    ActiveCell.Value = ""

     

    • Marked as answer by Gazza101 Wednesday, March 31, 2010 3:21 PM
    Wednesday, March 31, 2010 3:21 PM