bluesky6688
New Member
- Joined
- Dec 24, 2013
- Messages
- 34
Hello everyone,
I am working with an excel sheet that has hundreds different array formulas. I used "Find and Replace" to modify the formulas to create more new formulas, then I found I need to do the CSE for each cell.
I tried the code I found from Excel Forum but I got a error says "Run-time error '1004': Unable to set the FormulaArray properties of the Range class". The problem was from the line "UsrCell.FormulaArray = UsrCell.Formula".
Here is the link to that post:
I have posted a sample work at the end of the post.
Any ideas?
Thanks!
I am working with an excel sheet that has hundreds different array formulas. I used "Find and Replace" to modify the formulas to create more new formulas, then I found I need to do the CSE for each cell.
I tried the code I found from Excel Forum but I got a error says "Run-time error '1004': Unable to set the FormulaArray properties of the Range class". The problem was from the line "UsrCell.FormulaArray = UsrCell.Formula".
Here is the link to that post:
I have posted a sample work at the end of the post.
Any ideas?
Thanks!