B
BEETAL
For your Kind attention. Urgent help required.
I am running a macro (Function not Sub) which throws out 1000 data points
(x,y). For each y there is one x. I have managed to store the ys in an array.
Can someone please help me to chart these ys in sheet1,say. basically I
need to create a chart without pasting the data on the sheet.
Actually, when I run a Function, i am not being able to use the following
command to paste the generated data on the sheet. But it works in a SUB.
Cells(i + 10, j + 2).Value = spread(i, j) --> the spread values DO not get
pasted when asked to from a Function. In Sub it works. Why?
I am running a macro (Function not Sub) which throws out 1000 data points
(x,y). For each y there is one x. I have managed to store the ys in an array.
Can someone please help me to chart these ys in sheet1,say. basically I
need to create a chart without pasting the data on the sheet.
Actually, when I run a Function, i am not being able to use the following
command to paste the generated data on the sheet. But it works in a SUB.
Cells(i + 10, j + 2).Value = spread(i, j) --> the spread values DO not get
pasted when asked to from a Function. In Sub it works. Why?