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?

On 31 Dec 2007, 12:42, Khuli wrote:
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..

The 1024 is based on the R1C1 reference style.

Try testing your potential formula using .formulaR1C1





Khuli wrote:

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?

--

Dave Peterson