Why does this stop excell from working
 

Range(Cells(AvRow, 5), Cells(AvRow + myLines, 7)).FormulaR1C1Local(X,
y)=myArry(x*y-1)
stops excel from working when the watch pane show me the values i am
expecting to see. try it and see but save your work first

Why does this stop excell from working
 

Not easy to predict given unknown quantities for AvRow, myLines, X and y;
and the operation of function myArry !

--

Regards,
Nigel




"MK" wrote in message
...
Range(Cells(AvRow, 5), Cells(AvRow + myLines, 7)).FormulaR1C1Local(X,
y)=myArry(x*y-1)
stops excel from working when the watch pane show me the values i am
expecting to see. try it and see but save your work first