office 365 fixed 255 limit?

[daveyc18]

i recorded a macro with a long-*** formula that's over 1000 characters and it seemed to work when I ran the macro....i guess office 365 fixed the 255 character limit?

 

[Peter_SSs]

The max length of a formula is over 8000 characters as I recall

Rory's recollection is correct. From Excel's specifications ..

also found this link

How to overcome the max length limit of a formula in Excel? a bug of excel?

There are at least two forms of formula in Excel. One is used for cells, and the other is used for data validation. The max length limit for the formula to do data validation is about only 210 char...

stackoverflow.com

I believe that link is about the length of a Data Validation formula, not a worksheet cell formula.

 

[daveyc18]

Rory's recollection is correct. From Excel's specifications ..

View attachment 12784

I believe that link is about the length of a Data Validation formula, not a worksheet cell formula.

regardless ..Roy comment is what I was referring to

 

[daveyc18]

The max length of a formula is over 8000 characters as I recall but there was a bug in the macro recorder (not sure if it's still there) where very long formulas that would need splitting over multiple lines of code didn't get recorded properly - the recorder actually overwrote parts of the formula string with the necessary line continuation and concatenation symbols.

this must be it