Hey, thanks but I am now getting the message 'object doesn't support this property or method' and it does not hide the chart when the formula in cell a1 produces a blank value? any ideas??
thank you!