How Many Characters In A Formula?

M

Minitman

Greetings,

Does anyone how many characters are allowed in a cell formula?

Also, is there anyway to find out how many characters are actually in
a cell formula?

TIA

-Minitman
 
S

Steve Garman

Minitman said:
Greetings,

Does anyone how many characters are allowed in a cell formula?

32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the formula bar.
Also, is there anyway to find out how many characters are actually in
a cell formula?

MsgBox Len(ActiveCell.Formula)
 
S

Steve Garman

Sorry, I'm wrong.

The maximung length of a formula contents appears to be 1,024 characters
 
M

Minitman

Hey Steve,

Don't be sorry, a simple correction is all that is required and
appreciated,

1024, that's good to know. My biggest cells have 554 characters and
growing, just a bit over half full. <G>

Thanks for the reply, they both helped.

-Minitman
 
S

Steve Garman

Which suggests that the other part of my original reply should have been

MsgBox Len(ActiveCell.FormulaR1C1)
 
Top