Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.formula property bug?
I am using some vba which automatically creates a formula in a cell
(it adds successive staterments to the end of an existing formula) and decided to make it check if the formula length was going to exceed 1,024 characters. I created a long formula by hand, and in the immediate window typed: ? len(range("A1").formula) This gave an error, despite the formula being 1,012 characters long. Changing the formula bit by bit, I found that the above code only works if the formula is a maximum of 1,000 characters. Question 1: Is this a bug? Question 2: How can I check if a formula may exceed 1,024 characters, if the current length is valid, but checking the length as above gives an error? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Property value of class instance by passing string property name | Excel Programming | |||
Runtime error 380 - Could not set the list property. Invalid property value. | Excel Programming | |||
Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
setting formula property | Excel Programming |