Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
I use the following piece of code (I don't repeat here the declarations): For each cella in otherrng Range("A1").Select Selection.AutoFilter Field:=2, Criteria1:=cella Set txtteljes = ActiveSheet.AutoFilter.Range.Rows Set txtteljes = txtteljes.Offset(1, 0).Resize(txtteljes.Rows.Count - 1, txtteljes.Columns.Count) On Error Resume Next Set txtszurt = txtteljes.SpecialCells(xlVisible) On Error GoTo 0 If Not txtszurt Is Nothing Then Selection.Delete Shift:=xlUp End If Selection.AutoFilter Next My problem is that when range txtszurt is empty (I see on the screen that no rows are selected), the If Not txtszurt Is Nothing Then condition is still met, and all rows are deleted. What's wrong? Regards, Stefi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete some column headings from an autofiltered range. | Excel Worksheet Functions | |||
Test if the range is empty | Excel Discussion (Misc queries) | |||
why is range empty? | Excel Discussion (Misc queries) | |||
why is range empty? | Excel Programming | |||
Error stepping through Autofiltered visible range | Excel Programming |