Insert long formula into range

[chasmac]

Hi there,

Was given what I thought was the simple task of pasting a formula via a macro into a range of cells; unable to make it happen however. Works properly when pasted in cells as regular function. I've used the macro recorder to get the formula into vba, still no dice, error 1004, whether inserting into range or a single cell. I realize it is a long formula but I'm using Excel 2013, didn't think length would be an issue. Formula is sound, should work in a macro right? Anyways, here it is:

Please Login or Register  to view this content.

Any help much appreciated.

Chas

[Pauleyb]

Check this out. BTW, your string length is 3426 chars.
http://www.excelforum.com/excel-prog...ula-limit.html