.... or better still, put the 160 into a worksheet table and compare against
that.

--
__________________________________
HTH

Bob

"Rick Rothstein" wrote in message
...
Uh... don't use so many line continuations maybe? In case you are not
aware of what that message means... it occurs when you take a long line of
text an split it up on multiple lines using a space followed by an
underline to keep the links linked together. For example...

SomeTextVariable = "Line one which goes on for awhile and " & _
"then continues on, but one line lower"

If I recall correctly, there are a maximum of 25 line continuations that
can be used on a single code statement... so just don't break it apart so
often... or see if you can split the multiline statement you are trying to
construct into more than one statement, each of which can have a maximum
of 25 line continuations.

--
Rick (MVP - Excel)


"Gmata" wrote in message
...
I am trying to create a macro to filter about 160 brand names of 300, i
started recording a macro and then using filter, i checked all the brand
names i wanted, the problem is that when i finished i got the error msg "
Too
Many Line Continuations" what can i do to create a macro to filter only
those
160 or so brands?

Thanks