View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PGibson PGibson is offline
external usenet poster
 
Posts: 4
Default Programing with a "Find"

When a value is not found, the macro errors and stops. How can I trap the
error before it is reported and act on the error with out stopping the
macro?

Columns("F:F").Select
Selection.Find(What:="347", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:= _
xlNext, MatchCase:=False).Activate