Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to find text in my file then delete the entire row then find the next occurance of the same text, but my code is getting stuck on the findnext line. This is my code. Can you help me
Sub testcell3( Range("A6").Selec With ActiveSheet.Range("a6:I1000" Set P = .Find(what:="PAYMENT RECEIVED THANK YOU", after:=ActiveCell, LookIn :=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= xlNext, MatchCase:=False If Not P Is Nothing The FirstAddress = P.Addres D P.EntireRow.Delete Set P = .FindNext(P Loop While Not P Is Nothing And P.Address < FirstAddres End I End Wit End su |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Findnext | Excel Discussion (Misc queries) | |||
findnext issues | Excel Programming | |||
FindNext problem | Excel Programming | |||
FindNext problem when using PasteSpecial | Excel Programming | |||
problem with .FindNext | Excel Programming |