#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 51
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 14
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Close Excel mac help window BillyC in Ross Excel Discussion (Misc queries) 0 August 5th 06 07:25 PM
keystroke to close active workbook window Vickie Excel Worksheet Functions 4 December 7th 05 11:21 PM
How can you close a window with the back button in excel Holly Williams Excel Discussion (Misc queries) 0 September 20th 05 01:57 PM
Min/Max/Close buttons have disappeared from worksheet window Joodle Excel Discussion (Misc queries) 1 September 5th 05 12:42 AM
How do I close the page break window? 2jwayne New Users to Excel 1 May 18th 05 11:18 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"