Why does this stop excell from working

  • Thread starter Thread starter MK
  • Start date Start date
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
 
Not easy to predict given unknown quantities for AvRow, myLines, X and y;
and the operation of function myArry !
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help: 1004 Method 'Charts' of Object '_Global' failed 3
Help: 1004 Method 'Charts' of Object '_Global' failed 0
Excel VBA help: Text file formatting 19
Permutations andText to column problem 6
using search function in VBA 4
Text to Rows 2
Counter stops working 4
How to copy a range of cells from one sheet to another 4

Back
Top