Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Need help finishing code(??????). Once it finds "c", I want to paste that
value in cell "C4", but then PAUSE, and wait for user input. If the user selects "next", then loop to find the next "c". Thanks Sub Find() Dim myValue As Range Set myValue = Range("C5") With Worksheets(1).Range("a1:a100") Set c = .Find(myValue, LookIn:=xlValues) If Not c Is Nothing Then firstAddress = c.Address Do c.???????? Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address < firstAddress End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Findnext | Excel Discussion (Misc queries) | |||
FindNext | Excel Programming | |||
findnext issues | Excel Programming | |||
FindNext problem | Excel Programming | |||
problem with .FindNext | Excel Programming |