ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add method of SeriesCollection object clears Windows clipboard (https://www.excelbanter.com/excel-programming/363121-add-method-seriescollection-object-clears-windows-clipboard.html)

Richo

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.


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com