Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I stop this after the last life o I am new and not very good at thi
Sub life_o( Range("A1:A8000").Selec D Set FoundCell = Cells.Find(What:="life o", After:=ActiveCell, LookIn:=xlValues, LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False If FoundCell Is Nothing The Els FoundCell.Offset(0, 1).Selec End I FoundCell.Offset(0, 1).Selec ActiveCell.Value = "1 ActiveCell.Offset(0, -1).Selec Loop Until FoundCell Is Nothin End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Loop ? | Excel Discussion (Misc queries) | |||
Worksheet_Change - loop within a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
for-each-next loop | Excel Programming |