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