View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richo Richo is offline
external usenet poster
 
Posts: 2
Default Add method of SeriesCollection object clears Windows clipboard

N.S. if this behaviour is intended, but when I call the Add method of
SeriesCollection object in Excel VBA, the Windows clipboard gets cleared.

This behavior is consistent in Office 10 & 11, Win XP

Calling the Add method for other objects does not make this happen.

A workaround is to call SeriesCollection.NewSeries, and set the properties
of the new series manually. This does not affect the clipboard.