Find arguments
- From: "Zone" <KingOfWhiles@xxxxxxx>
- Date: Sat, 8 Sep 2007 09:29:39 -0400
When I use Find in code, I generally want a "no-frills" find, so
Set c = Cells.Find("abc")
works just fine to find "abc" in the values, any part of the values,
ignoring case. But, testing this, I see that if the user has set find
options differently, find remembers and searches according to those rules.
Rats! So I have to include arguments, like
Set c = Cells.Find("abc", LookIn:=xlValues, lookat:=xlPart,
MatchCase:=False)
Is there anyway to set find back to "no frills", or default settings, so I
don't have to include all those arguments? TIA, James
.
- Prev by Date: Re: Copy and Paste LAST ROW of data
- Next by Date: Re: Insert blank space
- Previous by thread: Copy and Paste LAST ROW of data
- Next by thread: Re: Find arguments
- Index(es):
Relevant Pages
|
