PDA

View Full Version : Solved: Search Formula limits exceeded



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

geekgirlau
05-20-2007, 08:36 PM
Rather than inserting the contents of the range into the formula, why don't you set the formula as:

=SEARCH(A5,CutArray)>0

spach
05-20-2007, 10:28 PM
It worked perfectly, many many thanks

geekgirlau
05-21-2007, 12:08 AM
My pleasure, and welcome to the Board :hi: .

Don't forget to mark this thread as "solved" (using the Thread Tools at the top of the page).