spach
05-20-2007, 10:52 AM
I have a formula that is populated from a named range.
i.e.
shtData.Cells(2, 1).Formula = "=search(a5,""" & Range("CutArray") & """)>0"
However the contents of the range ("CutArray") have exceeded 255 bytes in length and I get an error thrown.
Is it possible to split the search formula into 2 parts and apply it to the same cell?
Many thanks in advance for your help
i.e.
shtData.Cells(2, 1).Formula = "=search(a5,""" & Range("CutArray") & """)>0"
However the contents of the range ("CutArray") have exceeded 255 bytes in length and I get an error thrown.
Is it possible to split the search formula into 2 parts and apply it to the same cell?
Many thanks in advance for your help