| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Many Characters In A Formula?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Many Characters In A Formula?
Minitman wrote:
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) TIA -Minitman |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Many Characters In A Formula?
Sorry, I'm wrong.
The maximung length of a formula contents appears to be 1,024 characters Steve Garman wrote: Minitman wrote: 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) TIA -Minitman |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Many Characters In A Formula?
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 On Sun, 09 May 2004 08:02:46 +0100, Steve Garman wrote: Sorry, I'm wrong. The maximung length of a formula contents appears to be 1,024 characters Steve Garman wrote: Minitman wrote: 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) TIA -Minitman |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Many Characters In A Formula?
1024 as measured in R1C1 notation, too.
Steve Garman wrote: Sorry, I'm wrong. The maximung length of a formula contents appears to be 1,024 characters Steve Garman wrote: Minitman wrote: 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) TIA -Minitman -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How Many Characters In A Formula?
Which suggests that the other part of my original reply should have been
MsgBox Len(ActiveCell.FormulaR1C1) Dave Peterson wrote: 1024 as measured in R1C1 notation, too. Steve Garman wrote: Sorry, I'm wrong. The maximung length of a formula contents appears to be 1,024 characters Steve Garman wrote: Minitman wrote: 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) TIA -Minitman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula help with having characters in the number | Excel Discussion (Misc queries) | |||
| alpha characters in a formula | Excel Worksheet Functions | |||
| Too many characters in formula? | Excel Worksheet Functions | |||
| too many characters in formula | Excel Worksheet Functions | |||
| Formula for first three characters | Excel Programming | |||
![Minitman[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
