character limit in formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top