Why does this stop excell from working

M

MK

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
 
N

Nigel

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