array formula doesnt work from row 32737

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi
i'm using "array" formula in my excel macro and from some reason the
excel cannot populate the formula above 32737 rows,is there an option
to overcome this problem?
 
Hi,

Seeing the macro would have been helpful but my guess is you may mean 32,767
and this may be because you have a variable incorrectly Dimensioned as
integer. Dimension as long instead.

Mike
 
Try adding to arrays =sum(if(a1=a1:a32000,1,0))+sum(if(a1=a32001:a65535,1,0))

cntrl+shift+enter
 
this is one of the formulas
=IF(AE32737="","",IF(VLOOKUP(I32737,'AMR %'!J:AB,6,0)>0,VLOOKUP
(I32737,'AMR %'!J:AB,6,0)*9-4,INDEX(Definitions!$E$24:$E$273,MATCH(1,
(AE32737>=Definitions!$C$24:$C$273)*(AE32737<=Definitions!$D$24:$D
$273),0))))
and the last in line
 

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

Array Formula In IF Function 0
Vlookup error 5
Excel Wildcard in Excel array formula 0
Array formula does not calculate correctly when run from macro 10
Excel Help to copy information from one row at a time to another sheet 1
Array with excel sheet inside (need 2 code rows please) 3
Alternative to Application.Caller in array functions to avoid wrong results? 10
Insert Row also adds formulas and moves cursor 2

Back
Top