HELLO,
I AM WORKING ON A EXCEL SHEET WITH A MACRO DESCRIBED BELOW BUT WHEN THE IT DOES NOT FINDS THE TEXT I SEARCH OR FIND, IT DISPALYS AN ERROR MESSAGE BOX.
I WANT THAT IF THE SEARCHED TEXT IS NOT FOUND, THEN IT SHOULD DO NOTHING INSTEAD OF DISPLAYING THE ERROR MESSAGE BOX.
I WANT TO ADD IF CONDITION TO MY MACRO BUT DON'T KNOW HOW TO DO IT BECAUSE I KNOW VERY LITTLE ABOUT MACROS.
HERE IS THE MACRO I AM USING.
Sub prejudicedatefinder()
'
' prejudicedatefinder Macro
'
' Keyboard Shortcut: Ctrl+t
'
ActiveWindow.SmallScroll Down:=45
Cells.Find(What:="Order of Dismissal for Case", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Selection.Copy
Range("A14").Select
ActiveSheet.Paste
Range("B12").Select
End Sub
Bookmarks