| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter & clear cells
Hi All,
I am still siting whith a problem with the following: ActiveSheet.Outline.ShowLevels RowLevels:=0, ColumnLevels:=2 Selection.AutoFilter Field:=22, Criteria1:="#N/A" Cells(Range("V5").CurrentRegion.Offset(6, 0).SpecialCells(xlCellTypeVisible).Row, 22).Select Selection.CurrentRegion.Select Selection.ClearContents It worked perfectly well until i have a blank row in between the cells with "#N/A" in, it filters them all but it does not clear the cells after the blank row ? Please can someone help with this. Tempy *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I clear an Advanced Filter | Excel Worksheet Functions | |||
| The clear filter from a a heading cell is grey out | Excel Worksheet Functions | |||
| Clear Auto Filter on Close (or open) | Excel Discussion (Misc queries) | |||
| How to clear advanced filter in excel | Excel Discussion (Misc queries) | |||
| Filter & clear cells | Excel Programming | |||
Threaded Mode
