array formula doesnt work from row 32737
 

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?

array formula doesnt work from row 32737
 

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

"thread" wrote:

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?

array formula doesnt work from row 32737
 

Change any integer variables to Long.

--
__________________________________
HTH

Bob

"thread" wrote in message
...
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?

array formula doesnt work from row 32737
 

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

cntrl+shift+enter
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"thread" wrote:

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?

array formula doesnt work from row 32737
 

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<=Defi nitions!$D$24:$D
$273),0))))
and the last in line
On 25 ×*ובמבר, 17:50, Mike H wrote:
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



"thread" wrote:
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?-הסתר טקסט מצוטט-

-הר�ה טקסט מצוטט-