| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range Selection
Hello,
If I have a Total's line on line A5000, and sometimes it jumps to 5001 upto 5020 or more... Is there anyway to count the rows in between Lines 5000 and 5020 and then have the rows deleted? Any help would be greatly appreciated :) Thank you! Tim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Range Selection
K Dales...Thx...Thats great :) YEAH!
Tim "K Dales" wrote: For i = 5020 to 5000 step -1 If WorksheetFunction.CountA(Range(i & ":" & i)) = 0 Then Range("A" & i).EntireRow.Delete Next i "MrHappy" wrote: Hello, If I have a Total's line on line A5000, and sometimes it jumps to 5001 upto 5020 or more... Is there anyway to count the rows in between Lines 5000 and 5020 and then have the rows deleted? Any help would be greatly appreciated :) Thank you! Tim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
| Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
| Range Selection | Excel Discussion (Misc queries) | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
| Creating range name for a range selection | Excel Programming | |||
Linear Mode
