Results 1 to 2 of 2

Thread: FormulaArray Error - Unable to set the FormulaArray property of the range class

  1. #1
    Board Regular
    Join Date
    Jan 2009
    Posts
    199

    Default FormulaArray Error - Unable to set the FormulaArray property of the range class

    Hi guys,

    Wondering if anyone can help me.

    I am getting an error: "Unable to set the FormulaArray property of the range class" when I try to run the following code:

    Code:
    Range("AK3").FormulaArray = "=IF(ISNUMBER(SEARCH(1,$Y3)),SUM((MONTH($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))))=AK$2)*(WEEKDAY($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))),11)=1)),0) + IF(ISNUMBER(SEARCH(2,$Y3)),SUM((MONTH($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))))=AK$2)*(WEEKDAY($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))),11)=2)),0)"
    When I take out half of the formula, it seems to work though..ie, the following works:
    Code:
    Range("AK3").FormulaArray = "=IF(ISNUMBER(SEARCH(1,$Y3)),SUM((MONTH($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))))=AK$2)*(WEEKDAY($Z3-1+(ROW(INDIRECT(""1:""&$AA3-$Z3+1))),11)=1)),0)"
    When I paste in the full range into excel and do the ctrl+Shift+enter, the long one works!

    Has anyone got any ideas as to why this isn't working?

    Thanks,

    Eoin

  2. #2
    Board Regular
    Join Date
    Jan 2009
    Posts
    199

    Default Re: FormulaArray Error - Unable to set the FormulaArray property of the range class


Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com