| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find arguments
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
I'm afraid not. If those are the arguments you want .Find to use, and there
is a chance that they would be changed in the worksheet, then you have done what needs to be done. Your only alternative would be to close Excel and re-open it. The default settings would then be re-applied. Probably not what you want to do. Mike F "Zone" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
Thank you, Mike. If I remember my basic rules about arguments, I could
include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. I hope I haven't given anyone bad advice in here. I'll just include the arguments (and their names) with Find from now on. Regards, James "Mike Fogleman" wrote in message m... I'm afraid not. If those are the arguments you want .Find to use, and there is a chance that they would be changed in the worksheet, then you have done what needs to be done. Your only alternative would be to close Excel and re-open it. The default settings would then be re-applied. Probably not what you want to do. Mike F "Zone" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
"Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
Exactly, Rick!
"Rick Rothstein (MVP - VB)" wrote in message ... "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
Or even:
Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
LOL.. Well, yeah, technically, but I consider the first argument a
"given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
gd&r? Huh? Am I losing my web savvy? ;)
"Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
No, I saw the gd&r... I gave you a LOL in return.
Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r
means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
ty, Rick. I'm up to speed again! ;)
"Rick Rothstein (MVP - VB)" wrote in message ... Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
ty????
<gd&rvvf (Thank you) (Grin, duck and running, very very fast) Zone wrote: ty, Rick. I'm up to speed again! ;) "Rick Rothstein (MVP - VB)" wrote in message ... Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
thank you, maybe????
"Dave Peterson" wrote: ty???? <gd&rvvf (Thank you) (Grin, duck and running, very very fast) Zone wrote: ty, Rick. I'm up to speed again! ;) "Rick Rothstein (MVP - VB)" wrote in message ... Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
I think so, too.
JMB wrote: thank you, maybe???? "Dave Peterson" wrote: ty???? <gd&rvvf (Thank you) (Grin, duck and running, very very fast) Zone wrote: ty, Rick. I'm up to speed again! ;) "Rick Rothstein (MVP - VB)" wrote in message ... Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find arguments
tyvm, although maybe tmi for this ng, imho! <gd&r
"Dave Peterson" wrote in message ... I think so, too. JMB wrote: thank you, maybe???? "Dave Peterson" wrote: ty???? <gd&rvvf (Thank you) (Grin, duck and running, very very fast) Zone wrote: ty, Rick. I'm up to speed again! ;) "Rick Rothstein (MVP - VB)" wrote in message ... Whoops! The gd&r wasn't yours, was it? Ignore my other post... the gd&r means "grin, duck and run". Rick "Zone" wrote in message ... gd&r? Huh? Am I losing my web savvy? ;) "Rick Rothstein (MVP - VB)" wrote in message ... LOL.. Well, yeah, technically, but I consider the first argument a "given"... not too many people I know decide to place a first argument (whether it be "What" or anything thing else) out of sequence. Rick "Dave Peterson" wrote in message ... Or even: Set c=Cells.Find(what:="abc", ... <gd&r "Rick Rothstein (MVP - VB)" wrote: "Zone" wrote in message ... Thank you, Mike. If I remember my basic rules about arguments, I could include them without the argument names if I have them in the right order. But it's probably more trouble than it's worth (and definitely more dangerous) to try to remember where all those commas go. And much, much harder to read at some future date when you might be reviewing your code for some reason. Which of these do you think you would be able to figure out some months after you wrote them? Set c=Cells.Find("abc", LookIn:=xlValues, LookAt:=xlPart, MatchCase:=False) Set c=Cells.Find("abc", , xlValues, xlPart, , , False) Rick -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arguments | Excel Discussion (Misc queries) | |||
| IF-more than 7 arguments in | Excel Worksheet Functions | |||
| arguments | Excel Discussion (Misc queries) | |||
| Are there too many arguments | Excel Worksheet Functions | |||
| Where can I find other arguments & desc to the Workbooks.open("myfile.xls") cmd? | Excel Programming | |||
![Zone[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
