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