LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 31
Default Getting Excel Find to Default to Searching Workbook not Sheet

hi

I wanted to write a small autorun procedure to make the Find option to start
with assuming the whole workbook should be searched (rather than just the
sheet). However the syntax for the VBA does not include that argument
seemingly:
Cells.Find(What:="national i", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

Is there a workaround or alternative method?

Many thanks

Tim

PS I know there is an excellent FlexFind utility but I don't load any
add-ins unless I have to.

 
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
Set the Find and Replace, Options, 'Within' default to Workbook Paffer Excel Discussion (Misc queries) 1 September 10th 09 01:05 PM
how do I set up preferences for a workbook/sheet by default? WiFiMike2006 Excel Discussion (Misc queries) 2 January 18th 07 11:16 PM
How do I make the default FindWithinWorkbook in Excel? ISLHELPDESK Excel Discussion (Misc queries) 4 March 2nd 06 08:09 PM
changing the default type of searching in the find function Jose Roberto Excel Discussion (Misc queries) 1 November 29th 05 12:51 AM
EXCEL: Find data in worksheet and create a new sheet in same workbook Peacce Dog Excel Programming 3 November 18th 04 08:05 PM


All times are GMT +1. The time now is 09:09 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"