1. E

    Range.FormulaArray length problem

    After trying extensively with http://www.dailydoseofexcel.com/archives/2005/01/10/entering-long-array-formulas-in-vba/ with no luck, I decided to repost with an updated version of the problem. Let me explain, the solution in that post is fine, but it doesn't exaclty suit me because my...
  2. E

    FormulaArray property on a range

    I'm trying to assign (in excel 2003, sp3) a string to the FormulaArray property of a range. The length of the string is 305, causing a crash because it is maxed over 255 characters (the error and cause is documentated poorly at http://support.microsoft.com/kb/213181, I say poorly because at the...

Some videos you may like

This Week's Hot Topics