Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to limit .Find to a specific range
I am trying to find occurances of value within a range of cells.
Could someone help me with this code? tia For Each rngMyCell In rngMyRange With Cells Set rngMyCell = .Find(What:=strEdit_Find, After:=ActiveCell,_ LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False) If Not rngMyCell Is Nothing Then strFirstAddress = rngMyCell.Address Do strData = rngMyCell.Formula lCountValueReplaces = lCountValueReplaces + 1 Set rngMyCell = .FindNext(rngMyCell) Loop While Not rngMyCell Is Nothing And ngMyCell.Address < strFirstAddress End If End With Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
Limit Printing on specific worksheets in Excel | Excel Discussion (Misc queries) | |||
Find the bottom cell that contains a specific val in a range? | Excel Worksheet Functions | |||
find sum if one col = ? within specific date range | Excel Discussion (Misc queries) | |||
find numbers in a range that add to a specific value | Excel Discussion (Misc queries) |