We might be talking apples and oranges but I got this out of the Excel
specifications that is available in Excel help.

Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar

Maybe VBA is the problem.

"Dan" wrote:

I am trying to assingn via vba a formula that is more than 255 character.
using: range("A1"). formula = "bla blaa...."
is there a way around the 255 character limitation