XL97: Problems When Selecting Error Bars With a Macro

WORKAROUND

Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs. If you have limited programming experience, you may want to contact a Microsoft Certified Partner or the Microsoft fee-based consulting line at (800) 936-5200. For more information about Microsoft Certified Partners, please visit the following Microsoft Web site: For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site: It is possible to select one or the other set of error bars by using a Microsoft Excel version 4.0 macro language (XLM) command within your Visual Basic subroutine.

To select the x error bars for the first series in the active chart, use the following command:

   Application.ExecuteExcel4Macro ("SELECT(""Series 1 X Error Bars"")")
				

To select the y error bars for the first series in the active chart, use this command:

   Application.ExecuteExcel4Macro ("SELECT(""Series 1 Y Error Bars"")")
				

After the set of error bars is selected, you can format it by using Visual Basic code similar to the following:

   With Selection.Border
 
       .LineStyle = xlContinuous
       .ColorIndex = 3
       .Weight = xlThin
 
   End With
				

Or you can delete the selected set of error bars by using this Visual Basic command:

   Selection.Delete
				

   ActiveChart.SeriesCollection(1).ErrorBars.Select