![]() |
#5
|
|||
|
|||
![]()
Or like this
Code:
Sub jolivanes() Dim lr As Long, lc As Long Application.ScreenUpdating = False lr = Cells(Rows.Count, 4).End(xlUp).Row lc = Cells(1, Columns.Count).End(xlToLeft).Column With Range(Cells(1, 1), Cells(lr, lc)) .AutoFilter 4, "<11" .Range(.Cells(2, 1), .Cells(lr, lc)).SpecialCells(12).EntireRow.Delete End With ActiveSheet.AutoFilterMode = False Application.ScreenUpdating = True End Sub |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dennist77 | Word | 1 | 10-29-2013 11:39 PM |
![]() |
Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |
![]() |
j2b3 | Word Tables | 3 | 07-19-2012 03:59 PM |
![]() |
gib65 | Excel | 2 | 12-09-2011 02:09 PM |
![]() |
Learner7 | Excel | 1 | 04-19-2011 02:45 AM |