Maximum lenght for string? Or what's the issue?

Project is rolling forward but yet another crash. This time issue comes mainly from one ungodly long formula that I would need to fit into the macro. However it isn't working ATM and the length of it is causing "some" headache just in trying to figure out what the heck it's supposed to be doing! Finally I opted to split the formula in 3 parts(hoping I could figure out () parts right) and combine them in the end. However it isn't working and tossing 1004 run time errors.

Now why I'm asking is that in debugger the result text stops short in the locals view. Specifically shortly after part2 it cuts short and rest is missing. Is there maximum limit to string variables which I have exceeded(and which would obviously then cause runtime errors) or is there something other I'm missing? Again the original formula in the cell was working so that's not issue. It's something in my way of trying to do it in macro rather than directly in the cell.

And here's the code.

Edit: Removed as it's no longer needed

B and C columns are string variables that function this in in receives as arquments(and are coming in correctly as far as debugger can tell).

Edit: Sorry! Solved this myself finally. Just needed whole bunch of " more. You really need to be careful with those!

I *believe* in 2003 the limit in Excel is 1024 chars for formulae and your formula appears to sit within those boundaries (albeit we don't know the lengths of the variables to which you refer in the formula).

Without seeing the code in full & without knowing how your named ranges are set up it's hard to be precise.

To test the formula itself...

If you *can* write back the "result" to the cell as a String rather than a formula and then manually force to a formula in native XL does the formula evaluate correctly ?