ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   close find window (https://www.excelbanter.com/charts-charting-excel/163109-close-find-window.html)

Gklass

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

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


Arlette[_2_]

close find window
 
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



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com