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

Thanks Thanks:  0
Likes Likes:  0
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
    203
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    203
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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


User Tag List

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