close find window

G

Gklass

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

The macro recorder does not seem to record clicking on cancel.
 
A

Arlette

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top