Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/172114

From BetaArchive Wiki
Knowledge Base

Cannot Use Array of Data Points with Extend Method

Article ID: 172114

Article Last Modified on 8/17/2005


  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition

This article was previously published under Q172114


In the versions of Microsoft Excel listed at the beginning of this article, the Help topic for the Extend method states that the Source argument may be either a Range object or an array of data points. This information is incorrect; the Source argument must be a Range object.

If you run a Visual Basic for Applications macro that attempts to use an array of data points for the Source argument of the Extend method, you receive the following error message:

Run-time error '1004':
Reference is not valid.


In Microsoft Excel, you can use the Extend method to add new data points to an existing series in a chart. For example, if you create a simple column chart that contains a single series, and you want to add new data points to the series, you can use a line of code similar to the following:

   ActiveChart.SeriesCollection.Extend Worksheets("Sheet1").Range("B5:B6")

This line of code adds the values in cells B5:B6 in Sheet1 to the chart.

If you specify an array of data points for the Source argument of the Extend method, you receive an error message. For example, the following sample code causes the problem:

   Dim xExtras
   xExtras = Array(2, 3, 5, 7)
   ActiveChart.SeriesCollection.Extend xExtras

The problem occurs because xExtras refers to an array of data points, not to a Range object.

Additional query words: XL5 XL7 XL97 XL

Keywords: kbprogramming kbprb kbdtacode KB172114