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

"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?

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?

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?

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

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