I have some code that enters a long formula into a cell,
which worked great until I made the formula even longer.

Now it won't enter anything in the cell.

I tried using the macro recorder to insure no errors, but the macro recorded cuts off the end characters.

Also I can't seem to make the line continuation character ( _) work within my R1C1 formula. I can use it at the ".FormulaR1C1 = _" point, but not WITHIN the formula itself. I get an expected End of Statement Error.