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

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
(E-Mail Removed)
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<=Definitions!$D$24:$D
$273),0))))
and the last in line
On 25 ×*ובמבר, 17:50, Mike H <Mi...@discussions.microsoft.com> 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?-הסתר טקסט מצוטט-
>
> -הר�ה טקסט מצוטט-