Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sub DeleteHeadings()
Dim rng As Range Dim target As String target = InputBox("Enter Search Term") If target = "" Then Exit Sub Do If Not rng Is Nothing Then rng.Resize(8, 1).EntireRow.Delete End If Set rng = Nothing Set rng = Cells.Find(What:=target, _ After:=ActiveCell, _ LookIn:=xlFormulas, _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False) Loop While Not rng Is Nothing End Sub Can someone explain me in simple words what is this macro performing step by step. I would really appreciate that. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
name definition | Excel Programming | |||
Macro to Uncheck Save Query Definition | Excel Programming | |||
Range Definition in Macro ? | Excel Programming | |||
Syntax problem in defining OnAction macro definition held in Add-in! | Excel Programming | |||
Remove Query Definition with Macro or VBA | Excel Programming |