see the code
i want to create a XY scatter chart, using data from
y-axis = data from column 1 - row 3 to row 11 an
x-axis = data from column 4 - row 3 to row 11

Charts.Ad
ActiveChart.ChartType = xlXYScatterSmoothNoMarker
ActiveChart.SeriesCollection(1).Delet
ActiveChart.SeriesCollection.NewSerie
ActiveChart.SeriesCollection.NewSerie
ActiveChart.SeriesCollection(1).XValues = "='Sheet1'!R3C4:R11C4
ActiveChart.SeriesCollection(1).Values = "='Sheet1'!R3C1:R11C1

but the no of rows can be variable, so how can i pass no of rows (like "from row 3 to row 12" or "from row 3 to row 15") to the proceedure. i just want to pass 11 or 12 or 15 or whatever, instead of saying "Sheet1'!R3C4:R11C4

Is there any way..pls hel