#### bluesky6688

##### New Member

- Joined
- Dec 24, 2013

- Messages
- 34

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!