Macro error, range object need data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top