character limit in formula

D

Dan

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
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if previous "character" is a section break 3
Code character limit with Resize or Transpose or cell? 8
Macro to Select text from a point given to a specific word 2
Problem with MS Word paragraph and character styles: format getting messed up 2
Copy addition formula of non-consecutive horizontal cells 2
special character in vba 6
Moving extra characters to a new column 18
255 char limit on TextBox 3

Top