Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Issue with Find
I am using the following statements
Sheets("WAN").select If (Range("K2:K974").Find(What:="RTR23so-5/0/3", LookAt:=xlWhole).Select) = True Then Sheets("LAHORE_1 P Router (RTR23)").Range("D9").Value = ActiveCell.Offset(0, -8).Value Else Sheets("LAHORE_1 P Router (RTR23)").Range("D9").Value = "Not found" End If Everything is okay as long as the search string is found. If there is no match, then an error is returned. I tried using "On Error resume Next" but the resumption took place at the line immediately following the If statement. I do not want this, rather I want the code to continue with the Else statement. Please help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND & REPLACE ISSUE | Excel Discussion (Misc queries) | |||
find and replace issue in macro | New Users to Excel | |||
Find Issue (Menu Find) | Excel Discussion (Misc queries) | |||
Excel find and replace issue | Excel Discussion (Misc queries) | |||
Excel find and replace issue | Excel Discussion (Misc queries) |