To do this manually:

From the dropdown list in the column heading, choose Custom
From the first dropdown, choose Contains
In the text box, hold the Alt key, and on the number keypad,
type: 0010
Click OK

To filter programmatically, use Chr(10), e.g.:

Selection.AutoFilter Field:=4, _
Criteria1:="=*" & Chr(10) & "*", Operator:=xlAnd


solomon_monkey wrote:
If you have a line break character in an Excel Cell (i.e. you press Alt
& Enter) is there any way you can filter by cells containing this?
Regards,



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html