I have a custom class that is used to assist with Excel automation. I am trying to add a function to set the range of the labels for the x axis. I have tried many variations of the syntax but can't seem to get it right. My current try is

function SetXLabels(cRange)
	oSheet = this.oExcel.ActiveSheet
	this.oExcel.ActiveChart.SeriesCollection(1).XValues = oSheet.range(cRange)
	endfunc

If I was working without the custom class, this would work.

oExcel.Activechart.SeriesCollection(1).XValues = oSheet.range('A10:A22')

The function errors on the last line that says 'OLE error code 0x80020006: Unknown Name'
The value of cRange is "A10:A22"

Can someone help please.

Thanks