Length Limit for Excel Formula in VBA?

[ewong90]

Hi!

I have this really long Excel formula that I need to add to my VBA but for some reasons, it feels like there is a length limit for Excel formulas in VBA?

Thanks

 

[ewong90]

Oh how do you put it in a string variable? Sorry I am totally new on this whole VBA thing

 

[shg]

  Dim s As String
  
  s = "your formula"
  Debug.Print s

 

[Marcelo Branco]

It's a really long formula- not sure how many characters but def more than 1000 characters. How do you use line continuation though?

A formula with more than 1000 characters is really big...
I think you should show us a sample of your data and the results you want. Maybe we can create a shorter formula.

M.