View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Long Excel Formula in VBA gives error

No. It works fine for me using XL03 and XL04...


In article .com,
"Steve Mackay" wrote:

Ah, I think that is the problem...I am exceeding 255 chars. When I try
to use the code you put, I still get an error. Application definded or
object defined error.

So, a cell can only have a formula <255 chars