Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by line break
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by line break
Yes it's possible.
At the last row + 1, double click on cell and just press Alt+Enter. So this cell has only the line break nothing else. Inlcude this row when setting the Data filer. In filter chose Custom, and give following condition:- Contains: - Click on drop down and select the empty row (which will be at the top and contains the line break) And Does not end with:- Click the drop down and again selectg the same empty row. Sharad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by line break
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by line break
Thanks Debra... is there a similar simple code for filtering the colour
of a cell? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter by line break
You're welcome. There's nothing similar for code. You could add a column
to the table, and use some of Chip Pearson's code for extracting colour values. Then, filter on the new column. http://www.cpearson.com/excel/SortByColor.htm solomon_monkey wrote: Thanks Debra... is there a similar simple code for filtering the colour of a cell? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
line break does not appear in CSV | Excel Discussion (Misc queries) | |||
Line break within a field | Excel Worksheet Functions | |||
Line break | Excel Discussion (Misc queries) | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Line Break | Excel Discussion (Misc queries) |