The following forum(s) have migrated to Microsoft Q&A: Visual Basic for Applications (VBA)! Visit Microsoft Q&A to post new questions.
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?
I've sorted this one.
I don't know why the above happens but the following code gets me out of trouble.
ActiveCell.Value = ""
