Macro error, range object need data?

[Guest]

Hi all
How can I improve my macro which has a macro error like below:

"Macro error
The method can't be used in the applied context. Specifically, some Range
object methods require that the range contain data. If the range does not
contain data, the method fails."

How can I modify range object which has some empty data in the range?
Thanks
Daniel

 

[Andy Pope]

Hi,

Does the range you are referencing contain data? Empty cells or those
containing #N/A can cause problems when using the charting section of
the object model.

Cheers
Andy