I keep getting the "Unable to set FormulaArray property of the Range class error" error when trying to run the below macro. It's an array formula. Is it because it's over 256 characters? Any way of fixing it so it runs?
Please Login or Register to view this content.
Last edited by ScabbyDog; 01-24-2016 at 01:52 PM.
Hi ScabbyDog
Here's a sample of what you can do (split the formula into two parts) .Here's an example and you can change to suit your array formula
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Mhmm not working for me. For some reason I can't post the whole array formula here without a firewall intervening! Will attach sample book below.Originally Posted by YasserKhalil
Hi ScabbyDog
Here's a sample of what you can do (split the formula into two parts) .Here's an example and you can change to suit your array formula
Please Login or Register to view this content.
Last edited by ScabbyDog; 01-24-2016 at 02:52 PM. Reason: Linking to another post
My next post will contain sample workbook with the array formula inside.
Last edited by ScabbyDog; 01-24-2016 at 02:52 PM. Reason: Rules
Can you post a sample workbook ...?
No need for duplicate threads (this is forbidden : Cross-Post)
Final-Sample1.xlsm
Sample attached with code in macro. If someone can get it to run so that it puts the array formula in the cell then that's all I need!
May be the Test sub will do the task
Unfortunately not Yasser. Needs to be an array and all that does is return #VALUE!
Not even sure what that Evaluate formula you sent me does Yasser?
Anyone else able to help me out with the sample workbook?
Your sample is not the required .. I need a sample workbook with the array formula in the spreadsheet itself to try to offer help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks