.formula property bug?

[Khuli]

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?

 

[Khuli]

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?

Gentle bump..

 

[Dave Peterson]

The 1024 is based on the R1C1 reference style.

Try testing your potential formula using .formulaR1C1