![]() |
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. |
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