.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?
|