I have a macro that worked in my old version of office (2003). We were upgraded to 2010 and I cannot get it to work.
Data is a selection of random cells. ie A1 A3 A6 A9. I want to paste this data into a series collection.
Old Code:
data.Copy
.SeriesCollection.Paste Rowcol:=xlRows, NewSeries:=True
I figured out a little bit of the problem, but I need a little help. What do I need to enter as the first parameter?
retVal = seriesCollection1.Paste(data_xlRows???, "Series name", "Catagory Name", True, True)
Data is a selection of random cells. ie A1 A3 A6 A9. I want to paste this data into a series collection.
Old Code:
data.Copy
.SeriesCollection.Paste Rowcol:=xlRows, NewSeries:=True
I figured out a little bit of the problem, but I need a little help. What do I need to enter as the first parameter?
retVal = seriesCollection1.Paste(data_xlRows???, "Series name", "Catagory Name", True, True)
Last edited: