close find window

  • Thread starter Thread starter Gklass
  • Start date Start date
G

Gklass

Is there a macro command that will
close a "find" window?

The macro recorder does not seem to record clicking on cancel.
 
I have created a temporary workbook for this macro. Have 2 cols, Col
A having numbers from 1 to 10 and col B having alphabets A to J. I
have done a simple find for the alphabet "b". Its working for me
properly.

Sub test()

Range("B3").Select
Cells.Find(What:="b", After:=ActiveCell, LookIn:=xlFormulas,
LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).Activate
End Sub
 
Back
Top